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

From Bruce Momjian
Subject Re: table/index fillfactor control, try 3
Date
Msg-id 200607020222.k622MUE08602@momjian.us
Whole thread Raw
In response to table/index fillfactor control, try 3  (ITAGAKI Takahiro <itagaki.takahiro@oss.ntt.co.jp>)
Responses Re: table/index fillfactor control, try 3  (ITAGAKI Takahiro <itagaki.takahiro@oss.ntt.co.jp>)
List pgsql-patches
Patch applied.  Thanks.

Catalog version updated.

---------------------------------------------------------------------------


ITAGAKI Takahiro wrote:
> This is the 3rd revised fillfactor patch.
> Now, AM specific options are stored in pg_class.reloptions as text[].
> Also, some bugs are fixed. It passed all regression tests.
>
>
> Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
> > 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.
>
> The column format of options is changed from bytea to an array of text,
> so re-parsing is needed every time a connection accesses a relation.
> I changed to write pre-parsed options into pg_internal.init, but AFAICS,
> only system relations are written in it. If we will find the parsing
> is slow, it might be good to store options for user relations, too.
>
>
> Regards,
> ---
> ITAGAKI Takahiro
> NTT Open Source Software Center

[ Attachment, skipping... ]

[ Attachment, skipping... ]

>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
>                http://www.postgresql.org/docs/faq

--
  Bruce Momjian   bruce@momjian.us
  EnterpriseDB    http://www.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

pgsql-patches by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: ADD/DROPS INHERIT (actually INHERIT / NO INHERIT)
Next
From: Tom Lane
Date:
Subject: Re: ADD/DROPS INHERIT (actually INHERIT / NO INHERIT)