Re: toast tables on system catalogs - Mailing list pgsql-hackers

From Tom Lane
Subject Re: toast tables on system catalogs
Date
Msg-id 27934.1299017015@sss.pgh.pa.us
Whole thread Raw
In response to toast tables on system catalogs  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Responses Re: toast tables on system catalogs
List 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 by date:

Previous
From: daveg
Date:
Subject: Re: Re: [ADMIN] PD_ALL_VISIBLE flag was incorrectly set happend during repeatable vacuum
Next
From: Rumko
Date:
Subject: Re: Porting PostgreSQL to DragonFly BSD