Thread: Autovacuum Daemon is Turned On by Default in Postgres 8.3.8?
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 Postgres8.3.8. Does that mean that I no longer need to manually invoke the autovacuum command anymore? I used to do itmanually 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
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@gmail.com
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 tobe sure. Mary -----Original Message----- From: Adrian Klaver [mailto:adrian.klaver@gmail.com] Sent: Wednesday, June 02, 2010 6:08 PM To: pgsql-general@postgresql.org Cc: Wang, Mary Y Subject: Re: [GENERAL] 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@gmail.com
On Wednesday 02 June 2010 6:17:28 pm Wang, Mary Y wrote: > 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 > You don't have to, but you can still run those commands if needed. They are still there. -- Adrian Klaver adrian.klaver@gmail.com
On Wed, Jun 2, 2010 at 6:40 PM, Wang, Mary Y <mary.y.wang@boeing.com> 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 Postgres8.3.8. Does that mean that I no longer need to manually invoke the autovacuum command anymore? I used to do itmanually in an older version of Postgres. For most installations autovacuum with default settings is just fine. If you run a really busy site then you might have to adjust the parameters of autovac as well as the free space map.