Обсуждение: [HACKERS] Logical vs. Physical attribute numbering

Поиск
Список
Период
Сортировка

[HACKERS] Logical vs. Physical attribute numbering

От
Bruce Momjian
Дата:
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_--