Re: Default fill factor for tables?

On Fri, Jul 11, 2008 at 2:10 PM, Simon Riggs <simon@2ndquadrant.com> 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@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.

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.