| From: | Heikki Linnakangas <heikki(at)enterprisedb(dot)com> |
|---|---|
| To: | Gene Hart <genekhart(at)gmail(dot)com> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: choosing fillfactor |
| Date: | 2007-05-18 20:19:00 |
| Message-ID: | 464E0A34.6030802@enterprisedb.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tyrrill, Ed | 2007-05-18 21:22:52 | Re: Slow queries on big table |
| Previous Message | Tom Lane | 2007-05-18 20:06:09 | Re: Slow queries on big table |