Re: choosing fillfactor

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