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. > > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
