Re: table/index fillfactor control, try 2 - Mailing list pgsql-patches

From Tom Lane
Subject Re: table/index fillfactor control, try 2
Date
Msg-id 9422.1150503979@sss.pgh.pa.us
Whole thread Raw
In response to Re: table/index fillfactor control, try 2  (Simon Riggs <simon@2ndquadrant.com>)
Responses Re: table/index fillfactor control, try 2
table/index fillfactor control, try 3
List pgsql-patches
Simon Riggs <simon@2ndquadrant.com> writes:
> On Fri, 2006-06-16 at 13:33 +0900, ITAGAKI Takahiro wrote:
>> 2. Store the structures in AM's meta page. But heaps don't have meta pages.

> But perhaps they should? That sounds very similar to the idea of
> non-transactional pg_class data.

The disadvantage of putting this stuff into metapages is that then you
need some entirely new protocol for letting clients get at it (and
pg_dump, for one, needs to).  I agree with putting it in a catalog.

An opaque bytea won't do though.  What I'd suggest is something real
close to the format used for GUC parameters in ALTER DATABASE SET and
ALTER USER SET, ie, pairs of keyword/value strings.  This way pg_dump
doesn't need very much smarts about what the values are that it's
dumping.

            regards, tom lane

pgsql-patches by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: plpython improvements
Next
From: Sven
Date:
Subject: Re: plpython improvements