Re: [PERFORM] REINDEXing database-wide daily

2010-03-30 Thread Andy Colson
On 3/30/2010 4:32 AM, Gnanakumar wrote: Hi, We're using PostgreSQL 8.2. I have a question in connection to this question posted by me earlier: http://archives.postgresql.org/pgsql-performance/2010-03/msg00343.php In our application, DML operations (INSERT/UPDATE/DELETE) are heavily performed

Re: [PERFORM] REINDEXing database-wide daily

2010-03-30 Thread Kevin Grittner
Gnanakumar gna...@zoniac.com wrote: We're using PostgreSQL 8.2. Newer versions have much improved the VACUUM and CLUSTER features. You might want to consider upgrading to a later major version. I have a question in connection to this question posted by me earlier: