Re: Abnormal storage consumption with autovacuum enabled - Mailing list pgsql-admin

From Nicola Mauri
Subject Re: Abnormal storage consumption with autovacuum enabled
Date
Msg-id 46569EF1.1080106@saga.it
Whole thread Raw
In response to Abnormal storage consumption with autovacuum enabled  (Nicola Mauri <nicola.mauri@saga.it>)
Responses Re: Abnormal storage consumption with autovacuum enabled  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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




pgsql-admin by date:

Previous
From: "Marc G. Fournier"
Date:
Subject: Re: Loader
Next
From: Tom Lane
Date:
Subject: Re: Abnormal storage consumption with autovacuum enabled