[HACKERS] Logical vs. Physical attribute numbering

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема [HACKERS] Logical vs. Physical attribute numbering
Дата
Msg-id 200202210551.g1L5piM03851@candle.pha.pa.us
обсуждение исходный текст
Список pgsql-hackers
We had a discussion a few days ago about removing attribute padding from
disk storage structures to fit more information on the disk.

Now, I question whether it is worth the added complexity to do this, but
the idea of having different logical and physical numbering of columns
seems like it may solve several problems:
o Columns can be reordered to minimize paddingo We can move variable length columns to the end, improving  performance
oWe can fix inheritance problems in ADD COLUMNo We can implement fast DROP COLUMN by renumbering the column  out of
visibility

Comments?

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org


--ELM1018457966-21045-0_--


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

Предыдущее
От: Darren Johnson
Дата:
Сообщение: Re: A Replication Idea
Следующее
От: Bruce Momjian
Дата:
Сообщение: elog() proposals