Postgres Pro
Downloads
Home   >   mailing lists

Re: PG 8.0.1 is getting slow in 24 hours. Only daily VACUUM FULL helps - Mailing list pgsql-general

From Tom Lane
Subject Re: PG 8.0.1 is getting slow in 24 hours. Only daily VACUUM FULL helps
Date
Msg-id 3515.1118695503@sss.pgh.pa.us
Whole thread Raw
In response to PG 8.0.1 is getting slow in 24 hours. Only daily VACUUM FULL helps  (Együd Csaba <csegyud@vnet.hu>)
Responses Re: PG 8.0.1 is getting slow in 24 hours. Only daily VACUUM
List pgsql-general
Tree view 
=?iso-8859-2?Q?Egy=FCd_Csaba?= <csegyud@vnet.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

pgsql-general by date:

Previous
From: David Mitchell
Date:
Subject: Index problem
Next
From: Bruno Wolff III
Date:
Subject: Re: PG 8.0.1 is getting slow in 24 hours. Only daily VACUUM FULL helps