From: Joshua D. Drake <jd@commandprompt.com>
To: Carol Walter <walterc@indiana.edu>
Cc: pgsql-admin@postgresql.org
Subject: Re: Continuing issues... Can't vacuum!
Date: Fri, 23 May 2008 11:00:22 -0700
Message-ID: <1211565622.17493.24.camel@jd-laptop> (raw)
In-Reply-To: <5897F703-1525-477B-8749-80A0A4E0A656@indiana.edu>
References: <5897F703-1525-477B-8749-80A0A4E0A656@indiana.edu>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: jd@commandprompt.com, walterc@indiana.edu
Subject: Re: Continuing issues... Can't vacuum!
In-Reply-To: <1211565622.17493.24.camel@jd-laptop>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox