On Fri, 2008-07-11 at 12:52 -0600, Scott Marlowe wrote: > On Fri, Jul 11, 2008 at 12:12 PM, Richard Broersma > <[EMAIL PROTECTED]> wrote: > > On Fri, Jul 11, 2008 at 10:27 AM, Scott Marlowe <[EMAIL PROTECTED]> 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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general