Re: GUC for default heap fillfactor

Decibel! wrote:
-- Start of PGP signed section.
> On Thu, Aug 09, 2007 at 09:57:48AM +0900, ITAGAKI Takahiro wrote:
> > > If HOT gets into 8.3, we might need a GUC to set database wide heap
> > > fillfactor to an appropriate value.
> >
> > I have no objection to do that, but we will need other default values soon,
> > something like default_[heap|btree|hash|gist|gin]_fillfactor. Some of us
> > might feel it is mess to add random guc variables.
>
> I think we'd want to handle indexes with a different mechanism, probably
> one that makes changes to pg_am.
>
> In any case, how important is it to do this before 8.3? We were supposed
> to release this month, after all.

Agreed. This seems like 8.4 material once we have HOT usage in the
field.

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://www.enterprisedb.com

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