pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedchoosing fillfactor
2+ messages / 2 participants
[nested] [flat]
* choosing fillfactor
@ 2007-05-18 18:57 Gene Hart <genekhart@gmail.com>
0 siblings, 1 reply; 2+ messages in thread
From: Gene Hart @ 2007-05-18 18:57 UTC (permalink / raw)
To: 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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: choosing fillfactor
@ 2007-05-18 20:19 Heikki Linnakangas <heikki@enterprisedb.com>
parent: Gene Hart <genekhart@gmail.com>
0 siblings, 0 replies; 2+ messages in thread
From: Heikki Linnakangas @ 2007-05-18 20:19 UTC (permalink / raw)
To: Gene Hart <genekhart@gmail.com>; +Cc: 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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2007-05-18 20:19 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-05-18 18:57 choosing fillfactor Gene Hart <genekhart@gmail.com>
2007-05-18 20:19 ` Heikki Linnakangas <heikki@enterprisedb.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox