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

Поиск
Список
Период
Сортировка
От Qingqing Zhou
Тема Re: PG 8.0.1 is getting slow in 24 hours. Only daily VACUUM FULL helps
Дата
Msg-id d8o2s3$1fqh$1@news.hub.org
обсуждение исходный текст
Ответ на PG 8.0.1 is getting slow in 24 hours. Only daily VACUUM FULL helps  (Együd Csaba <csegyud@vnet.hu>)
Список pgsql-general
"Tom Lane" <tgl@sss.pgh.pa.us> writes
>
> Evidently that's not often enough.  Or it could be that your
> FSM settings aren't large enough?
>

Setting various proper parameters of FSM is onerous for maintainence. Is
there any plan to make FSM buffer-file-able, just like what clog does now?

Regards,
Qingqing



В списке pgsql-general по дате отправления:

Предыдущее
От: Tatsuo Ishii
Дата:
Сообщение: Re: PostgreSQL Certification
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Bad pg_xlog with no redo