Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group