Re: Redundant syscache access in get_rel_sync_entry()

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Redundant syscache access in get_rel_sync_entry()
Дата
Msg-id 2247647.1720751308@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Redundant syscache access in get_rel_sync_entry()  (Michael Paquier <michael@paquier.xyz>)
Список pgsql-hackers
Michael Paquier <michael@paquier.xyz> writes:
> On Thu, Jul 11, 2024 at 07:10:58PM +0530, Ashutosh Bapat wrote:
>> I think it's just convenient. We do that at multiple places; not exactly
>> these functions but functions which fetch relation attributes from cached
>> tuples. Given that the tuple is cached and local to the backend, it's not
>> too expensive.  But if there are multiple places which do something like
>> this, we may want to create more function get_rel_* function which return
>> multiple properties in one function call. I see get_rel_namspace() and
>> get_rel_name() called together at many places.

> That's not worth the complications based on the level of caching.
> This code is fine as-is.

I could get behind creating such functions if there were a
demonstrable performance win, but in places that are not hot-spots
that's unlikely to be demonstrable.

            regards, tom lane



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Clang function pointer type warnings in v14, v15
Следующее
От: Richard Guo
Дата:
Сообщение: Re: Should consider materializing the cheapest inner path in consider_parallel_nestloop()