Re: Abnormal storage consumption with autovacuum enabled

From: Nicola Mauri <nicola(dot)mauri(at)saga(dot)it>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Abnormal storage consumption with autovacuum enabled
Date: 2007-05-25 08:31:45
Message-ID: 46569EF1.1080106@saga.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

> What do you have max_fsm_pages set to?

Currently, max_fsm_pages=20000

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?

thanks

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2007-05-25 13:57:19 Re: Abnormal storage consumption with autovacuum enabled
Previous Message Marc G. Fournier 2007-05-25 08:09:59 Re: Loader