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

Поиск
Список
Период
Сортировка
От Együd Csaba
Тема Re: PG 8.0.1 is getting slow in 24 hours. Only daily VACUUM
Дата
Msg-id 0II700C83YVHFN@mail.vnet.hu
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: Greg Stark
Дата:
Сообщение: Re: Advice on structure /sequence / trigger
Следующее
От: Jacob Atzen
Дата:
Сообщение: Backing up multiple databases