Re: rapid degradation after postmaster restart

From: Joe Conway <mail(at)joeconway(dot)com>
To: Marty Scholes <marty(at)outputservices(dot)com>
Cc: pgsql-performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: rapid degradation after postmaster restart
Date: 2004-03-13 16:07:12
Message-ID: 405331B0.6080102@joeconway.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers 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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Josh Berkus 2004-03-13 16:51:22 Re: rapid degradation after postmaster restart
Previous Message Joe Conway 2004-03-13 16:03:25 Re: rapid degradation after postmaster restart

Browse pgsql-performance by date

  From Date Subject
Next Message Josh Berkus 2004-03-13 16:51:22 Re: rapid degradation after postmaster restart
Previous Message Joe Conway 2004-03-13 16:03:25 Re: rapid degradation after postmaster restart