From: Joshua D. Drake <jd@commandprompt.com>
To: Doug Gorley <doug.gorley@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: How can I tell if I'm autovacuuming?
Date: Sat, 22 May 2010 10:11:23 -0700
Message-ID: <1274548283.8730.99.camel@jd-desktop.unknown.charter.com> (raw)
In-Reply-To: <4BF7E14B.6030800@gorley.ca>
References: <4BF7E14B.6030800@gorley.ca>
On Sat, 2010-05-22 at 09:51 -0400, Doug Gorley wrote:
> From what I see in the docs, these three settings in postgresql.conf
> should be enough for PostgreSQL (8.2) to autovacuum with the default
> settings:
>
> autovacuum = on
> stats_start_collector = on
> stats_row_level = on
>
> So, two questions:
>
> (a) Is this correct? Should autovacuum be functional now?
If you restarted.
> (b) How can I verify that my databases are being vacuumed by autovacuum?
pg_stat_user_tables should have a last_autovac column.
>
> Thanks,
>
> --
> Doug Gorley | doug@gorley.ca
>
>
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564
Consulting, Training, Support, Custom Development, Engineering
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: jd@commandprompt.com, doug.gorley@gmail.com
Subject: Re: How can I tell if I'm autovacuuming?
In-Reply-To: <1274548283.8730.99.camel@jd-desktop.unknown.charter.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox