Re: Default fill factor for tables?

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: "Simon Riggs" <simon(at)2ndquadrant(dot)com>
Cc: "Richard Broersma" <richard(dot)broersma(at)gmail(dot)com>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, lists(at)stringsutils(dot)com, "Pgsql General list" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Default fill factor for tables?
Date: 2008-07-11 20:51:17
Message-ID: dcc563d10807111351s49612873rfca5d1dd5cbcaa@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Jul 11, 2008 at 2:10 PM, Simon Riggs <simon(at)2ndquadrant(dot)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(dot)broersma(at)gmail(dot)com> wrote:
>> > On Fri, Jul 11, 2008 at 10:27 AM, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2008-07-11 20:53:08 Re: recovery do not finish
Previous Message Alvaro Herrera 2008-07-11 20:31:17 Re: Default fill factor for tables?