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
Ответ на
Список
Дерево обсуждения
Redundant syscache access in get_rel_sync_entry() "cca5507" <cca5507@qq.com>
Re: Redundant syscache access in get_rel_sync_entry() Ashutosh Bapat <ashutosh.bapat.oss@gmail.com>
Re: Redundant syscache access in get_rel_sync_entry() "cca5507" <cca5507@qq.com>
Re: Redundant syscache access in get_rel_sync_entry() Michael Paquier <michael@paquier.xyz>
Re: Redundant syscache access in get_rel_sync_entry() Tom Lane <tgl@sss.pgh.pa.us>
Michael Paquier  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
Дата:
От: Richard Guo
Дата:
FAQ