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

Re: Continuing issues... Can't vacuum!

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Carol Walter <walterc(at)indiana(dot)edu>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Continuing issues... Can't vacuum!
Date: 2008-05-23 18:00:22
Message-ID: 1211565622.17493.24.camel@jd-laptop (view raw or flat)
Thread:
Lists: pgsql-admin

On Fri, 2008-05-23 at 13:54 -0400, Carol Walter wrote:
> Hello,

> vacuumdb: vacuuming database "km"
> NOTICE:  number of page slots needed (2275712) exceeds max_fsm_pages  
> (200000)
> HINT:  Consider increasing the configuration parameter  
> "max_fsm_pages" to a value over 2275712.
> 
> The problem is I've found the max_fsm_pages parameter in the  
> postgresql.conf file, but changing it doesn't seem to be having any  
> effect. 

You have to restart the database.

>  So I'm going to ask some questions that are probably pretty  
> silly, but I hope you'll help me.  First of all, perhaps the  
> postgresql.conf file that I am editing may not be the one that is  
> being read when the database server starts.  There are several  
> postgresql.conf files on this system.  How do I tell which one is the  
> one being read?

Woah... :)

>From psql: show config_file;


> The max_fsm_pages parameter says what the minimum setting is in the  
> file.  Is there also a maximum?
> 

It is limited by your shared memory but consider that is not your
problem. Your problem is you don't vacuum enough. My suggestion is to do
the following:

Up the max_fsm_pages a considerable amount
Restart
Vacuum the entire database
backup
reinitialize with backup
make sure you are vacuuming properly.

Sincerely,

Joshua D. Drake



In response to

Responses

pgsql-admin by date

Next:From: Jeff FrostDate: 2008-05-23 18:02:34
Subject: Re: Continuing issues... Can't vacuum!
Previous:From: Carol WalterDate: 2008-05-23 17:54:02
Subject: Continuing issues... Can't vacuum!

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