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

From Madison Kelly
Subject Re: DB is slow until DB is reloaded
Date
Msg-id 4B425D79.7010302@alteeve.com
Whole thread Raw
In response to Re: DB is slow until DB is reloaded  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-performance
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

pgsql-performance by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: DB is slow until DB is reloaded
Next
From: Madison Kelly
Date:
Subject: Re: DB is slow until DB is reloaded