On Thu, 2010-04-01 at 19:17 +0530, raghavendra t wrote: > > Hi All, > > System Config > --------------------- > CPU - Intel® Xenon® CPU > CPU Speed - 3.16 GHz > Server Model - Sun Fire X4150 > RAM-Size - 16GB > > Steve: > So am I to understand I don't need to do daily reindexing as a > maintenance measure with 8.3.7 on FreeBSD. > > My question is something like Steve's, why we should not do reindexing > as our maintenance task. I was doing reindex only to get > a best fit and not fall short of 90% hole, bcoz my table has lot of > updates and deletes. We also has the weekly maintance of VACUUM, but > still reindex takes lot of time.
This is your problem. You should enable autovaccuum, let the vacuums happen more frequently, and this problem will go away. You will still have to fix the underlying bloat a last time though. -- Brad Nicholson 416-673-4106 Database Administrator, Afilias Canada Corp. -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
