Re: Default fill factor for tables? - Mailing list pgsql-general

On Fri, 2008-07-11 at 12:52 -0600, Scott Marlowe wrote:
> On Fri, Jul 11, 2008 at 12:12 PM, Richard Broersma
> <richard.broersma@gmail.com> wrote:
> > On Fri, Jul 11, 2008 at 10:27 AM, Scott Marlowe <scott.marlowe@gmail.com> wrote:
> >
> >> Is there any way to set a different default fill factor?
> >
> > ALTER TABLE Yourtable
> >        SET ( FILLFACTOR = 50 );
>
> Hehe.  I know how to do that. I mean the default fill factor for a
> database / user for tables / indexes..  Like setting search_path for a
> user.

I think the reasoning was/is that setting it away from the default is
only sensible in certain table-specific cases, so such a setting would
more likely result in a general drop in performance.

--
 Simon Riggs           www.2ndQuadrant.com
 PostgreSQL Training, Services and Support