Postgres Pro
Downloads
Home   >   mailing lists

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

From Qingqing Zhou
Subject Re: PG 8.0.1 is getting slow in 24 hours. Only daily VACUUM FULL helps
Date
Msg-id d8o2s3$1fqh$1@news.hub.org
Whole thread Raw
In response to PG 8.0.1 is getting slow in 24 hours. Only daily VACUUM FULL helps  (Együd Csaba <csegyud@vnet.hu>)
List pgsql-general
Tree view 
"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 by date:

Previous
From: Tatsuo Ishii
Date:
Subject: Re: PostgreSQL Certification
Next
From: Tom Lane
Date:
Subject: Re: Bad pg_xlog with no redo