On Mon, Jul 13, 2009 at 1:31 PM, Wayne Conrad<wayne@xxxxxxxxxxxx> wrote: > Howdy. Some months back, when advised on one of these lists that it > should not be necessary to issue VACUUM FULL/REINDEX DATABASE, we quit > this nightly "maintenance" practice. We've been very happy to not > have to do that, since it locked the database all night. Since then, > however, our database performance has decreased. The decrease took a > few weeks to become noticable; perhaps six weeks to become awful. SNIP > What options do I have for restoring performance other than VACUUM > FULL/REINDEX DATABASE? Just wondering, which pgsql version, and also, do you have autovacuum turned on? -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
