Re: number of attributes in page files?

Поиск
Список
Период
Сортировка
От Mario Weilguni
Тема Re: number of attributes in page files?
Дата
Msg-id 200210111600.13876.mweilguni@sime.com
обсуждение исходный текст
Ответ на Re: number of attributes in page files?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Am Freitag, 11. Oktober 2002 14:12 schrieb Tom Lane:
> Mario Weilguni <mweilguni@sime.com> writes:
> > Is it possible to get rid of the "t_natts" fields in the tuple header?
> > Is this field only for "alter table add/drop" support?
>
> "Only"?  A lot of people consider that pretty important ...

With "only" I mean it's an administrative task which requires operator intervenation anyways, and it's a seldom needed
operationwhich may take longer, when 
queries become faster.

>
> But removing 2 bytes isn't going to save anything, on most machines,
> because of alignment considerations.

ok, I did not consider alignment, but the question remains, is this easily doable? Especially because only one another
bytehas to be saved for 
real saving on many architectures, which is t_hoff. IMO t_hoff is not useful because it can be computed easily. This
wouldgive 20 byte headers instead of 23 (24) bytes as it's now.  
This is 17% saved, and if it's not too complicated it might be worth to consider.

Best regards,
    Mario Weilguni

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

Предыдущее
От: "Shridhar Daithankar"
Дата:
Сообщение: Re: Peer to peer replication of Postgresql databases
Следующее
От: Greg Copeland
Дата:
Сообщение: Re: MySQL vs PostgreSQL.