Postgres Pro
Downloads
Home   >   mailing lists

Re: Autovacuum does not stay turned off - Mailing list pgsql-performance

From hubert depesz lubaczewski
Subject Re: Autovacuum does not stay turned off
Date
Msg-id 20080826170423.GA29849@depesz.com
Whole thread Raw
In response to Re: Autovacuum does not stay turned off  (Jerry Champlin <jchamplin@absolute-performance.com>)
Responses Re: Autovacuum does not stay turned off
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: "Frank Joerdens"
Date:
Subject: Re: Query w empty result set with LIMIT orders of magnitude slower than without (SOLVED, pls disregard)
Next
From: Mark Lewis
Date:
Subject: Re: select on 22 GB table causes "An I/O error occured while sending to the backend." exception