Re: autovacuum not running

From: Ben <bench(at)silentmedia(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: autovacuum not running
Date: 2007-08-29 20:27:47
Message-ID: Pine.LNX.4.64.0708291303100.17514@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, 28 Aug 2007, Decibel! wrote:

> 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?

Doh! I was looking at last_vacuum. Unfortunately, the *last_autovaccum*
column is completely blank on the tables I'm inserting into, so I guess
it's never worked there.

But I do see the stats collector running, and upping the log level to
debug2 does show that the autovacuum at least starts running, and never
seems to have any errors.

.....hmmmm......

After some tests, it seems that autovacuum doesn't kick in from simple
inserts, as the manual says it will. You have to delete and/or update as
well. Am I misreading the manual?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Gregory Stark 2007-08-29 21:22:32 Re: Reliable and fast money transaction design
Previous Message Greg Smith 2007-08-29 19:26:06 Re: Shared memory usage