Re: ALTER TABLE ... ALTER COLUMN ... SET DISTINCT

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: ALTER TABLE ... ALTER COLUMN ... SET DISTINCT
Дата
Msg-id 9591.1238900162@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: ALTER TABLE ... ALTER COLUMN ... SET DISTINCT  (Alvaro Herrera <alvherre@commandprompt.com>)
Список pgsql-hackers
Alvaro Herrera <alvherre@commandprompt.com> writes:
> FWIW it has been said that whoever is concerned about pg_attribute bloat
> should be first looking at getting rid of the redundant entries for
> system columns, for each and every table.

That's been overtaken by events, unfortunately: we now need those
entries to carry per-column permissions on system columns.  So they're
no longer merely overhead.

Possibly we could hack things so that only system columns with
non-default permissions are actually stored, but that feels like
a kluge.
        regards, tom lane


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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: a few crazy ideas about hash joins
Следующее
От: Robert Haas
Дата:
Сообщение: Re: ALTER TABLE ... ALTER COLUMN ... SET DISTINCT