Re: autovacuum not running - Mailing list pgsql-general

From Tom Lane
Subject Re: autovacuum not running
Date
Msg-id 12210.1188427039@sss.pgh.pa.us
Whole thread Raw
In response to Re: autovacuum not running  (Ben <bench@silentmedia.com>)
List pgsql-general
Ben <bench@silentmedia.com> writes:
> 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?

There's nothing to vacuum until you delete or update.

You should see some auto-analyze activity on an insert-only table, but
not vacuuming.

            regards, tom lane

pgsql-general by date:

Previous
From: Ken.Colson@sage.com
Date:
Subject: show connection limit?
Next
From: Jessie
Date:
Subject: Npgsql GUI problem C#.net