Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id CE1629FB6B7 for ; Thu, 30 Aug 2007 10:23:09 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 31475-05 for ; Thu, 30 Aug 2007 10:23:05 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from sd-2317.dedibox.fr (sd-2317.dedibox.fr [88.191.17.192]) by postgresql.org (Postfix) with ESMTP id DAD419FB6C0 for ; Thu, 30 Aug 2007 10:23:05 -0300 (ADT) Received: from sd-2317.dedibox.fr (localhost.localdomain [127.0.0.1]) by sd-2317.dedibox.fr (Postfix) with ESMTP id 2A8F4D4EE; Thu, 30 Aug 2007 15:23:01 +0200 (CEST) Received: from [192.168.10.67] (ASte-Genev-Bois-153-1-28-65.w83-112.abo.wanadoo.fr [83.112.74.65]) by sd-2317.dedibox.fr (Postfix) with ESMTP id DA2DAD478; Thu, 30 Aug 2007 15:23:00 +0200 (CEST) Message-ID: <46D6C4B3.1040502@lelarge.info> Date: Thu, 30 Aug 2007 15:22:59 +0200 From: Guillaume Lelarge User-Agent: Thunderbird 2.0.0.6 (X11/20070728) MIME-Version: 1.0 To: Alvaro Herrera CC: Kevin Kempter , pgsql-admin@postgresql.org Subject: Re: transaction ID query References: <200708300647.36023.kevin@kevinkempterllc.com> <20070830131248.GB5872@alvh.no-ip.org> In-Reply-To: <20070830131248.GB5872@alvh.no-ip.org> Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: ClamAV using ClamSMTP X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/411 X-Sequence-Number: 26742 Alvaro Herrera a écrit : > Kevin Kempter wrote: > [...] >> b) a list of tables in the db and the last time they were vacuumed > > Examine the pg_stat views, though I am not sure if the vacuum columns > were already in 8.1. In any case, in 8.1 Xid wraparound is tracked > per-database, so you need database-wide vacuums. In 8.2 it is per table > so it is easier to keep up to date. > last vacuum information is available on 8.2, not 8.1. See http://www.postgresql.org/docs/8.2/interactive/monitoring-stats.html Regards. -- Guillaume.