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 0II700C83YVHFN@mail.vnet.hu
Whole thread Raw
List pgsql-general
Hi,
thank you very much for suggestions. It seems to be OK.

I set the FSM related variables 200 times higher then the default values.
The database has been working stable for 3 days. Just as before, when the
databas was empty.

BTW, isn't it too high to increase these values to 200 times higher? What
kind of problems it can cause?

-- Csaba

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




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


pgsql-general by date:

Previous
From: Greg Stark
Date:
Subject: Re: Advice on structure /sequence / trigger
Next
From: Jacob Atzen
Date:
Subject: Backing up multiple databases