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

Dear Tom, Bruno,

thank you for your reply. Since these parameters
(max_fsm_pages,max_fsm_relations) can be set at server startup, I have to
wait for at least the evening - and plus a few days letting the system going
wrong or better, staying good. :)

I'm going to inform you about the results.

Thank you very much.

-----Original Message-----
From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Sent: Monday, June 13, 2005 10:45 PM
To: Együd Csaba
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] PG 8.0.1 is getting slow in 24 hours. Only daily
VACUUM FULL helps

=?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

--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.323 / Virus Database: 267.6.9 - Release Date: 2005.06.11.

--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.323 / Virus Database: 267.6.9 - Release Date: 2005.06.11.