I used to execute the VACCUM and ANALYZE commands manually in a Postgres 7.x.x version. So my question was that I assume that I no longer have to perform those two commands manually anymore. I just wanted to be sure. Mary -----Original Message----- From: Adrian Klaver [mailto:adrian.klaver@xxxxxxxxx] Sent: Wednesday, June 02, 2010 6:08 PM To: pgsql-general@xxxxxxxxxxxxxx Cc: Wang, Mary Y Subject: Re: Autovacuum Daemon is Turned On by Default in Postgres 8.3.8? On Wednesday 02 June 2010 5:40:58 pm Wang, Mary Y wrote: > Hi, > > I'm looking at my log file (see my log file below) and it seems like > the autovacuum daemon is turned on by default in Postgres 8.3.8. Does > that mean that I no longer need to manually invoke the autovacuum > command anymore? I used to do it manually in an older version of Postgres. > > tail postgresql-2010-06-02_000000.log > DEBUG: autovacuum: processing database "template1" > DEBUG: server process (PID 31719) exited with exit code 0 > DEBUG: autovacuum: processing database "marydatabase" > DEBUG: server process (PID 31729) exited with exit code 0 > DEBUG: autovacuum: processing database "postgres" > DEBUG: server process (PID 31739) exited with exit code 0 > DEBUG: autovacuum: processing database "template1" > DEBUG: server process (PID 31741) exited with exit code 0 > DEBUG: autovacuum: processing database "marydatabase" > DEBUG: server process (PID 31753) exited with exit code 0 > > Thanks > Mary You talking about manually invoking Vacuum or autovacuum? -- Adrian Klaver adrian.klaver@xxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
