choosing fillfactor
choosing fillfactor
От:
Gene Hart <genekhart@gmail.com>
Дата:
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
Re: choosing fillfactor
От:
Heikki Linnakangas <heikki@enterprisedb.com>
Дата:
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
