> What do you have max_fsm_pages set to?
Running VACUUM VERBOSE reports:
NOTICE: number of page slots needed (237312) exceeds max_fsm_pages (20000)
HINT: Consider increasing the configuration parameter "max_fsm_pages" to a value over 237312.
Is this measurement reliable?
We are considering to set: max_fsm_pages=400000
Could this have some sort of impact?
pgsql-admin by date
|Next:||From: Tom Lane||Date: 2007-05-25 13:57:19|
|Subject: Re: Abnormal storage consumption with autovacuum enabled |
|Previous:||From: Marc G. Fournier||Date: 2007-05-25 08:09:59|
|Subject: Re: Loader|