[GENERAL] 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 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_00.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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
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_00.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.kla...@gmail.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Autovacuum Daemon is Turned On by Default in Postgres 8.3.8?
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.kla...@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_00.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.kla...@gmail.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Autovacuum Daemon is Turned On by Default in Postgres 8.3.8?
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.kla...@gmail.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Autovacuum Daemon is Turned On by Default in Postgres 8.3.8?
On Wed, Jun 2, 2010 at 6:40 PM, Wang, Mary Y mary.y.w...@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 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. 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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general