Re: Default fill factor for tables? - Mailing list pgsql-general

From Simon Riggs
Subject Re: Default fill factor for tables?
Date
Msg-id 1215811441.4051.1664.camel@ebony.2ndQuadrant
Whole thread Raw
In response to Re: Default fill factor for tables?  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Responses Re: Default fill factor for tables?
List pgsql-general
On Fri, 2008-07-11 at 14:51 -0600, Scott Marlowe wrote:

> 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.

You clearly think that adjusting fillfactor helps in all cases with HOT.
I disagree with that, else would have pushed earlier for exactly what
you suggest. In fact, I've has this exact discussion previously.

--
 Simon Riggs           www.2ndQuadrant.com
 PostgreSQL Training, Services and Support


pgsql-general by date:

Previous
From: William Garrison
Date:
Subject: How do I tell if a vacuum is currently running?
Next
From: Simon Riggs
Date:
Subject: Re: recovery do not finish