In response to "Phoenix Kiula" <[EMAIL PROTECTED]>: > Thanks for a very informative post! One question: > > > I'm not sure how to find the current value, but a smaller fill factor > > on busy tables should lead to less fragmentation, thus more efficient > > indexes over time. Keep in mind that a smaller fill factor will also > > lead to larger indexes initially. > > What constitutes a "small fill factor"? Would 70 be good?
Unfortunately, I can't say. I have not yet had the opportunity to experiment with different fillfactors, so I can only speak in vague estimations on this topic. > I guess my > current must have been the default, which the manual says is 100. I expect it's at the default, but the docs say that is 90%: http://www.postgresql.org/docs/8.2/static/sql-createindex.html Where did you see 100? > Or > did you mean really small fill factor like 20? In this context, what > is "packing" in the manual -- is that some kind of compression? Hopefully, someone more knowledgeable will chime in with some wise suggestions. Barring that, I can only suggest you experiment to find what works for your workload, but don't rule out the possibility that extremely low fillfactor values might work well for you. -- Bill Moran http://www.potentialtech.com ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
