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@xxxxxxxxx> wrote: > > On Fri, Jul 11, 2008 at 10:27 AM, Scott Marlowe <scott.marlowe@xxxxxxxxx> 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
