On Friday 14 November 2003 01:33, Rick Gigger wrote: > Are there any guidelines on how often one should do a reindex?
Vacuum in 7.4 does take care of index bloat, much better than earlier versions. So if you run autovacuum daemon with 7.4, then you can do away with reindex. Of course testing at your site will provide the best answer. There is no better tests than that..:-) Shridhar ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster