Re: toast tables on system catalogs

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: toast tables on system catalogs
Дата
Msg-id 27934.1299017015@sss.pgh.pa.us
обсуждение исходный текст
Ответ на toast tables on system catalogs  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Ответы Re: toast tables on system catalogs  (Alvaro Herrera <alvherre@commandprompt.com>)
Список pgsql-hackers
Alvaro Herrera <alvherre@alvh.no-ip.org> writes:
> Strangely, we made pg_database have a toast table, and the only reason
> for this is datacl.  Should we create toast tables for the remaining
> catalogs?

As I commented on your blog, this is nonsense.  pg_database has a TOAST
table becase we thought it might need one for datconfig[].  Now that
that's gone, it'd be consistent to remove the toast table, but it didn't
occur to us to do that.

aclitem entries wide enough to need toasting are going to suck for all
sorts of reasons (IIRC there are some O(N^2) algorithms in there, not
to mention the cost of pulling in entries from a toast table on every
access) so I am not excited about encouraging people to use them.
        regards, tom lane


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

Предыдущее
От: daveg
Дата:
Сообщение: Re: Re: [ADMIN] PD_ALL_VISIBLE flag was incorrectly set happend during repeatable vacuum
Следующее
От: Rumko
Дата:
Сообщение: Re: Porting PostgreSQL to DragonFly BSD