Skip site navigation (1) Skip section navigation (2)

Re: autovacuum not running

From: Decibel! <decibel(at)decibel(dot)org>
To: Ben <bench(at)silentmedia(dot)com>
Cc: Alvaro Herrera <alvherre(at)commandprompt(dot)com>,pgsql-general(at)postgresql(dot)org
Subject: Re: autovacuum not running
Date: 2007-08-29 01:32:20
Message-ID: 20070829013220.GT1386@nasby.net (view raw or flat)
Thread:
Lists: pgsql-general
On Tue, Aug 28, 2007 at 03:10:34PM -0700, Ben wrote:
> Hm, I assumed it wasn't running because pg_stat_all_tables shows the last
> vacuum from several weeks ago, and this is an active db. Also, I see no 
> vacuum activity in the logs. But "show autovacuum" does show it being 
> on....

Last vacuum, or last autovacuum?
-- 
Decibel!, aka Jim Nasby                        decibel(at)decibel(dot)org
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)

In response to

Responses

pgsql-general by date

Next:From: Alvaro HerreraDate: 2007-08-29 01:45:09
Subject: Re: autovacuum not running
Previous:From: Decibel!Date: 2007-08-29 01:28:41
Subject: Re: Reliable and fast money transaction design

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group