Re: PG 8.0.1 is getting slow in 24 hours. Only daily VACUUM FULL helps

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Együd Csaba <csegyud(at)vnet(dot)hu>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: PG 8.0.1 is getting slow in 24 hours. Only daily VACUUM FULL helps
Date: 2005-06-13 20:45:03
Message-ID: 3515.1118695503@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

=?iso-8859-2?Q?Egy=FCd_Csaba?= <csegyud(at)vnet(dot)hu> writes:
> The critical tables are vacuum analyzed in every hour.

Evidently that's not often enough. Or it could be that your
FSM settings aren't large enough?

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruno Wolff III 2005-06-13 20:50:45 Re: PG 8.0.1 is getting slow in 24 hours. Only daily VACUUM FULL helps
Previous Message David Mitchell 2005-06-13 20:37:38 Index problem