Thread: choosing fillfactor

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

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