Re: choosing fillfactor - Mailing list pgsql-performance

From Heikki Linnakangas
Subject Re: choosing fillfactor
Date
Msg-id 464E0A34.6030802@enterprisedb.com
Whole thread Raw
In response to choosing fillfactor  (Gene Hart <genekhart@gmail.com>)
List pgsql-performance
Gene Hart wrote:
> I've tried searching the documentation to answer this question but could
> not find anything. When trying to choose the optimal fillfactor for an
> index, what is important the number of times the row is updated or the
> column indexed upon is updated? In my case each row is updated on
> average about 5 times but for some of the columns with indexes don't
> change after insertion ever. thanks for any advice

It's the number of times the row is updated, regardless of which columns
are changed.


--
   Heikki Linnakangas
   EnterpriseDB   http://www.enterprisedb.com

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Slow queries on big table
Next
From: "Tyrrill, Ed"
Date:
Subject: Re: Slow queries on big table