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

From Együd Csaba
Subject Re: PG 8.0.1 is getting slow in 24 hours. Only daily VACUUM
Date
Msg-id 0II20038KO7L0Q@mail.vnet.hu
Whole thread Raw
In response to Re: PG 8.0.1 is getting slow in 24 hours. Only daily VACUUM FULL helps  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
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@sss.pgh.pa.us]
Sent: Monday, June 13, 2005 10:45 PM
To: Együd Csaba
Cc: pgsql-general@postgresql.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@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

--
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.


pgsql-general by date:

Previous
From: Alex Stapleton
Date:
Subject: Re: Hash Function: MD5 or other?
Next
From: Együd Csaba
Date:
Subject: Strange Create function behavior