Quick Links

Re: DB is slow until DB is reloaded

From:	"Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To:	"Madison Kelly" <linux(at)alteeve(dot)com>, "Gary Doades" <gpd(at)gpdnet(dot)co(dot)uk>
Cc:	<pgsql-performance(at)postgresql(dot)org>
Subject:	Re: DB is slow until DB is reloaded
Date:	2010-01-04 21:03:48
Message-ID:	4B420354020000250002DCC4@gw.wicourts.gov
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-performance

Madison Kelly <linux(at)alteeve(dot)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

In response to

Re: DB is slow until DB is reloaded at 2010-01-04 20:53:41 from Madison Kelly

Responses

Re: DB is slow until DB is reloaded at 2010-01-04 21:28:25 from Madison Kelly
Re: DB is slow until DB is reloaded at 2010-01-06 01:04:32 from Scott Carey

Browse pgsql-performance by date

	From	Date	Subject
Next Message	Madison Kelly	2010-01-04 21:28:25	Re: DB is slow until DB is reloaded
Previous Message	Brad Nicholson	2010-01-04 21:00:56	Re: DB is slow until DB is reloaded