Re: rapid degradation after postmaster restart - Mailing list pgsql-performance

From Joe Conway
Subject Re: rapid degradation after postmaster restart
Date
Msg-id 405331B0.6080102@joeconway.com
Whole thread Raw
In response to Re: rapid degradation after postmaster restart  (Marty Scholes <marty@outputservices.com>)
List pgsql-performance
Marty Scholes wrote:
> I have seen similar results to what you are describing.
>
> I found that running a full vacuum:
>
> vacuumdb -fza
>
> followed by a checkpoint makes it run fast again.
>
> Try timing the update with and without a full vacuum.

Will do. I'll let you know how it goes.

Thanks for the reply.

Joe


pgsql-performance by date:

Previous
From: Joe Conway
Date:
Subject: Re: rapid degradation after postmaster restart
Next
From: Josh Berkus
Date:
Subject: Re: rapid degradation after postmaster restart