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

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

From: Carol Walter <walterc(at)indiana(dot)edu>
To: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Continuing issues... Can't vacuum!
Date: 2008-05-23 18:35:19
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
Oh, yes.  I have restarted it several times - or at least I thought  
that I did.  Actually, it's not stopping.  I grepped for "post" after  
I did the stop and it is still running.  I really don't like the idea  
of issuing the kill command on the database processes.  Is there  
another option?

On May 23, 2008, at 2:00 PM, Joshua D. Drake wrote:

> 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
> -- 
> Sent via pgsql-admin mailing list (pgsql-admin(at)postgresql(dot)org)
> To make changes to your subscription:

In response to


pgsql-admin by date

Next:From: Joshua D. DrakeDate: 2008-05-23 18:39:40
Subject: Re: Continuing issues... Can't vacuum!
Previous:From: Jeff FrostDate: 2008-05-23 18:02:34
Subject: Re: Continuing issues... Can't vacuum!

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