Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql Admin > Continuing issu...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 8 Topic 5009 of 5549
Post > Topic >>

Continuing issues... Can't vacuum!

by walterc@[EMAIL PROTECTED] (Carol Walter) May 23, 2008 at 01:54 PM

Hello,

I posted yesterday about a corrupt index.  I'm continuing to  
experience problems.  I know that part of my problem is that the  
databases have not been vacuumed as they should have been.  I've  
tried to vacuum them but it's not working.  The message I'm getting  
is as follows:

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.  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?

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

I can't back up my database with the error right now, because of the  
error.  I have a backup but I'm afraid to restore it.  I feel like I  
have many indices that are bloated and I want to get the databases  
vacuumed before I start trying to create and load a new database.   
I'm concerned that there won't be enough index space for the system  
to  sort and copy the indices.

Please, help.

Carol



-- 
Sent via pgsql-admin mailing list (pgsql-admin@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
 




 8 Posts in Topic:
Continuing issues... Can't vacuum!
walterc@[EMAIL PROTECTED]  2008-05-23 13:54:02 
Re: Continuing issues... Can't vacuum!
jd@[EMAIL PROTECTED] (&q  2008-05-23 11:00:22 
Re: Continuing issues... Can't vacuum!
walterc@[EMAIL PROTECTED]  2008-05-23 14:35:19 
Re: Continuing issues... Can't vacuum!
walterc@[EMAIL PROTECTED]  2008-05-23 14:52:46 
Re: Continuing issues... Can't vacuum!
jeff@[EMAIL PROTECTED] (  2008-05-23 14:15:33 
Re: Continuing issues... Can't vacuum!
jeff@[EMAIL PROTECTED] (  2008-05-23 11:02:34 
Re: Continuing issues... Can't vacuum!
walterc@[EMAIL PROTECTED]  2008-05-23 15:08:39 
Re: Continuing issues... Can't vacuum!
scott.marlowe@[EMAIL PROT  2008-05-23 13:23:54 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Sat Nov 22 17:15:59 CST 2008.