Re: DB is slow until DB is reloaded

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

Kevin Grittner wrote:
> 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

Ah, noted and updated, thank you.

Madi

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Madison Kelly 2010-01-04 21:33:07 Re: DB is slow until DB is reloaded
Previous Message Kevin Grittner 2010-01-04 21:03:48 Re: DB is slow until DB is reloaded