From: hubert depesz lubaczewski <depesz@depesz.com>
To: Jerry Champlin <jchamplin@absolute-performance.com>
Cc: pgsql-performance@postgresql.org, Andrew Sullivan <ajs@commandprompt.com>
Subject: Re: Autovacuum does not stay turned off
Date: Tue, 26 Aug 2008 19:04:23 +0200
Message-ID: <20080826170423.GA29849@depesz.com> (raw)
In-Reply-To: <48B4332B.4050207@absolute-performance.com>
References: <48B420F4.5020406@absolute-performance.com>
<20080826161427.GA25880@depesz.com>
<48B4332B.4050207@absolute-performance.com>
On Tue, Aug 26, 2008 at 10:45:31AM -0600, Jerry Champlin wrote:
> This makes sense. What queries can I run to see how close to the limit
> we are? We need to determine if we should stop the process which
> updates and inserts into this table until after the critical time this
> afternoon when we can perform the required maintenance on this table.
select datname, age(datfrozenxid) from pg_database;
Best regards,
depesz
--
Linkedin: http://www.linkedin.com/in/depesz / blog: http://www.depesz.com/
jid/gtalk: depesz@depesz.com / aim:depeszhdl / skype:depesz_hdl / gg:6749007
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: depesz@depesz.com, jchamplin@absolute-performance.com, ajs@commandprompt.com
Subject: Re: Autovacuum does not stay turned off
In-Reply-To: <20080826170423.GA29849@depesz.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