choosing fillfactor

From: Gene Hart <genekhart(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: choosing fillfactor
Date: 2007-05-18 18:57:32
Message-ID: 464DF71C.5010805@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Alan Hodgson 2007-05-18 19:08:41 Re: 121+ million record table perf problems
Previous Message Brian Hurt 2007-05-18 18:53:42 Re: 121+ million record table perf problems