From: Scott Marlowe <scott.marlowe@gmail.com>
To: Reuven M. Lerner <reuven@lerner.co.il>
Cc: Greg Smith <greg@2ndquadrant.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Triggering autovacuum
Date: Sat, 11 Jun 2011 21:55:03 -0600
Message-ID: <BANLkTimQL2KVS=MaePCGOvjnATxsWTdH3w@mail.gmail.com> (raw)
In-Reply-To: <4DF3EE47.2040308@lerner.co.il>
References: <4DF0E5A0.7080101@lerner.co.il>
<4DF0FA36.2010802@2ndquadrant.com>
<4DF3EE47.2040308@lerner.co.il>
On Sat, Jun 11, 2011 at 4:37 PM, Reuven M. Lerner <reuven@lerner.co.il> wrote:
> Hi, Greg. Thanks for the quick and useful answer, even if it means that my
> hopes for a quick fix have been dashed. I guess I'll need to do some actual
> monitoring, then...
You mention pg_stat_user_tables, what did the last_analyze column for
those tables say?
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-performance@postgresql.org
Cc: scott.marlowe@gmail.com, reuven@lerner.co.il, greg@2ndquadrant.com
Subject: Re: Triggering autovacuum
In-Reply-To: <BANLkTimQL2KVS=MaePCGOvjnATxsWTdH3w@mail.gmail.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