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. autovacuum can be tricky... 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... not an expert here... but these are important topics regarding autovacuum... 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... -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
