Skip site navigation (1) Skip section navigation (2)

Re: Autovacuum does not stay turned off

From: hubert depesz lubaczewski <depesz(at)depesz(dot)com>
To: Jerry Champlin <jchamplin(at)absolute-performance(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org,Andrew Sullivan <ajs(at)commandprompt(dot)com>
Subject: Re: Autovacuum does not stay turned off
Date: 2008-08-26 17:04:23
Message-ID: 20080826170423.GA29849@depesz.com (view raw or flat)
Thread:
Lists: pgsql-performance
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(at)depesz(dot)com / aim:depeszhdl / skype:depesz_hdl / gg:6749007

In response to

Responses

pgsql-performance by date

Next:From: Mark LewisDate: 2008-08-26 17:10:15
Subject: Re: select on 22 GB table causes "An I/O error occuredwhile sending to the backend." exception
Previous:From: Frank JoerdensDate: 2008-08-26 16:59:49
Subject: Re: Query w empty result set with LIMIT orders of magnitude slower than without (SOLVED, pls disregard)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group