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@xxxxxxxxxxxxx] Sent: Monday, June 13, 2005 10:45 PM To: Együd Csaba Cc: pgsql-general@xxxxxxxxxxxxxx Subject: Re: PG 8.0.1 is getting slow in 24 hours. Only daily VACUUM FULL helps =?iso-8859-2?Q?Egy=FCd_Csaba?= <csegyud@xxxxxxx> 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. ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
