On Fri, Jul 11, 2008 at 2:10 PM, Simon Riggs <simon@xxxxxxxxxxxxxxx> wrote: > > 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. I would kindly disagree. I'm looking at a project where HOT updates are going to be a real performance enhancement, but I'll have to create a hundred or so tables ALL with fillfactor tacked on the end. Imagine dumping a db, setting the new target DB to default fill factors and then reloading all the data from the dump. No need to edit the dump file or a schema dump etc... I could definitely see a lot of use cases for a default fill factor.
