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: 3C9DB43B-9B3D-4E55-B4DE-37E83A1CA136@indiana.edu (view raw or flat)
Thread:
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?

Carol
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:
> http://www.postgresql.org/mailpref/pgsql-admin


In response to

Responses

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-2014 The PostgreSQL Global Development Group