Request a Demo
Home   >   mailing lists

Re: DB is slow until DB is reloaded - Mailing list pgsql-performance

From Kevin Grittner
Subject Re: DB is slow until DB is reloaded
Date
Msg-id 4B420354020000250002DCC4@gw.wicourts.gov
Whole thread Raw
In response to Re: DB is slow until DB is reloaded  (Madison Kelly <linux@alteeve.com>)
Responses Re: DB is slow until DB is reloaded
Re: DB is slow until DB is reloaded
List pgsql-performance
Tree view 
Madison Kelly <linux@alteeve.com> wrote:

> I've added CLUSTER -> ANALYZE -> VACUUM to my nightly
> routine and dropped the VACUUM FULL call.

The CLUSTER is probably not going to make much difference once
you've eliminated bloat, unless your queries do a lot of searches in
the sequence of the index used.  Be sure to run VACUUM ANALYZE as
one statement, not two separate steps.

-Kevin

pgsql-performance by date:

Previous
From: Brad Nicholson
Date:
Subject: Re: DB is slow until DB is reloaded
Next
From: Madison Kelly
Date:
Subject: Re: DB is slow until DB is reloaded