That output looks good with your settings. It means you are using 501 of the
1000 max_fsm_relations and 57328 of the 153600 max_fsm_pages.
The check_postgres.pl nagios plugin that Greg Sabino Mullane maintains
recently added a check for FSM settings. Check it out here:
http://bucardo.org/ch
HI Jeff,
Thank you for the link to explain FSM however I understand the concept where
it would be faster to know where to store data based on an insert or an
update but the results of the last few lines of the verbose I still don't get
it.
Our max_fsm_relations = 1000 and max_fsm_pages=153600
On Fri, Sep 12, 2008 at 12:51 PM, Fabricio <[EMAIL PROTECTED]> wrote:
>
> I have a reindex of my databases periodically
>
> Sorry for the English translation of google
> I have PostgreSQL 8.1.x
> The databases that we have has many updates and were being slow, revising
> found that some index were
mas rapida y el indice quedo muy pequeño.Por lo tanto puse una tarea programada
que me reidex mis bases de datos periodicamente.
> Date: Fri, 12 Sep 2008 12:40:19 -0400> From: [EMAIL PROTECTED]> To:
> pgsql-admin@postgresql.org> Subject: Re: [ADMIN] Recommend dba maintenanc
On Fri, Sep 12, 2008 at 9:49 AM, Barbara Stephenson
<[EMAIL PROTECTED]> wrote:
> Hello,
>
> We are currently using Postgresql 8.3.3 on Red Hat 4 and our largest database
> is around 8454 MB.
>
> I have recommend the below to my group but not sure if reindexing should be
> involved since autovacuum
On Fri, 12 Sep 2008, Barbara Stephenson wrote:
1- pg_dump - binary dump every midday and nightly
2 - auto vacuum
3- rotate data logs
You should also consider running a script which does a VACUUM VERBOSE weekly
or twice monthly and emails you the last 8 lines of output. This will allow
you t
On Fri, Sep 12, 2008 at 11:49:46AM -0400, Barbara Stephenson wrote:
> I have recommend the below to my group but not sure if reindexing should be
> involved since autovacuum is on?
No, there's no reason to reindex regularly if everything is working as
expected.
>
> How can I be sure auto vac
Hello,
We are currently using Postgresql 8.3.3 on Red Hat 4 and our largest database
is around 8454 MB.
I have recommend the below to my group but not sure if reindexing should be
involved since autovacuum is on?
How can I be sure auto vacumming is working fine? We haven't had any problems
