Re: Facing Problem in Autovacuuming Deamon.... - Mailing list pgsql-general

From Joao Ferreira
Subject Re: Facing Problem in Autovacuuming Deamon....
Date
Msg-id 1277227916.4938.43.camel@debj5n.critical.pt
Whole thread Raw
In response to Facing Problem in Autovacuuming Deamon....  (Deven <devendra@covacsis.com>)
List pgsql-general
Hello,

On Tue, 2010-06-22 at 04:50 -0700, Deven wrote:
> Hi all,
>
> I am using Postgresql Database for our system storage and I am running
> Autovacuuming Deamon on my entire database. But on of the table set in my
> database never undergoes the Autovacuuming. I always need to do the manual
> vacuuming on that table.

the way autovacuum behaves on each table will depend very much on the
INSERT/UPDATE profile in that specific table

so it's not necessarilly a problem if a given table never gets vacuumed;
may be it does not need;

can you be more specific on

a) why do you say that that specific table does not get autovacuumed ?
what makes you say that ?
b) is your filesystem experiencing bloat (bloat means: postgres seems to
start eating up disk space like crazy after some days/weeks/months) ? is
it ?
c) do the logs say things regarding max_fsm_pages ?
d) what version of postgres is it ?
e) have a closer look at the "autovacuum_*" configuration directives...

Cheers
JOao

>
> Can anyone kindly tell me the solution for the same problem.Do I need to do
> any configurations to come out of this problem?
>
> Waiting for reply...
>
> Thanks and Regards,
> Devendra Mule.
> Covacsis Technologies Pvt. Ltd.
> IIT, Mumbai.
> --
> View this message in context:
http://old.nabble.com/Facing-Problem-in-Autovacuuming-Deamon....-tp28959155p28959155.html
> Sent from the PostgreSQL - general mailing list archive at Nabble.com.
>
>


pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: libpython - cannot open shared object file
Next
From: Joao Ferreira gmail
Date:
Subject: Re: Facing Problem in Autovacuuming Deamon....