Re: Smaller data types use same disk space

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Smaller data types use same disk space
Дата
Msg-id 3201.1343248506@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Smaller data types use same disk space  ("McGehee, Robert" <Robert.McGehee@geodecapital.com>)
Ответы Re: Smaller data types use same disk space  (Mike Christensen <mike@kitchenpc.com>)
Список pgsql-general
"McGehee, Robert" <Robert.McGehee@geodecapital.com> writes:
> One might even imagine a future version of PostgreSQL using an
> efficient disk layout that may not match the table layout in order to
> avoid wasted space from padding.

Yeah, this has been discussed multiple times.  The sticking point is
the extra infrastructure needed to have a physical column numbering
different from the user-visible numbering, and the 100% certainty of
introducing a lot of bugs due to bits of code using one type of column
number where they should have used the other.  We'll probably get it
done someday, but don't hold your breath ...

            regards, tom lane

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

Предыдущее
От: Rachel Owsley
Дата:
Сообщение: Re: General guidance: Levenshtein distance versus other similarity algorithms
Следующее
От: Mark Phillips
Дата:
Сообщение: Re: BI tools and postgresql