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 по дате отправления: