Re: Save a few bytes in pg_attribute

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: Save a few bytes in pg_attribute
Дата
Msg-id 20230321201146.yukskxrfsmb5n6jj@awork3.anarazel.de
обсуждение исходный текст
Ответ на Re: Save a few bytes in pg_attribute  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Hi,

On 2023-03-21 15:26:38 -0400, Tom Lane wrote:
> Matthias van de Meent <boekewurm+postgres@gmail.com> writes:
> > ... with that patch we actually don't need the attcacheoff in the
> > pg_atttribute struct: it only needs to be present in the derived
> > "TupleAttrAlignData" structs which carry the
> > length/alignment/storage/byval info.
> 
> Yeah, I was wondering about that too: keeping attcacheoff as local
> state in slots might get us all its win without so much conceptual
> dirtiness.

It's also the place where it's the least likely to help - afaict attcacheoff
is only really beneficial for fastgetattr(). Which conditions it's use more
strictly - not only can there not be any NULLs before the accessed column,
there may not be any NULLs in the tuple at all.

Greetings,

Andres Freund



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

Предыдущее
От: Matthias van de Meent
Дата:
Сообщение: Re: Save a few bytes in pg_attribute
Следующее
От: Sergei Kornilov
Дата:
Сообщение: Re: [PATCH] Tracking statements entry timestamp in pg_stat_statements