On Mon, Jul 13, 2009 at 1:31 PM, Wayne Conrad<wayne@databill.com> 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?