From: Madison Kelly <linux@alteeve.com>
To: Kevin Grittner <Kevin.Grittner@wicourts.gov>
Cc: Gary Doades <gpd@gpdnet.co.uk>
Cc: pgsql-performance@postgresql.org
Subject: Re: DB is slow until DB is reloaded
Date: Mon, 04 Jan 2010 16:28:25 -0500
Message-ID: <4B425D79.7010302@alteeve.com> (raw)
In-Reply-To: <4B420354020000250002DCC4@gw.wicourts.gov>
References: <4B423D22.7040803@alteeve.com>
<4B424215.70605@pinpointresearch.com>
<4B424FF6.40207@alteeve.com>
<4B425222.7070905@gpdnet.co.uk>
<4B425555.6020709@alteeve.com>
<4B420354020000250002DCC4@gw.wicourts.gov>
Kevin Grittner wrote:
> 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
Ah, noted and updated, thank you.
Madi
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: linux@alteeve.com, Kevin.Grittner@wicourts.gov, gpd@gpdnet.co.uk
Subject: Re: DB is slow until DB is reloaded
In-Reply-To: <4B425D79.7010302@alteeve.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox