Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 93A076336E1 for ; Thu, 12 Nov 2009 08:08:43 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 48972-10 for ; Thu, 12 Nov 2009 12:08:35 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mx3.uci.cu (ns3.uci.cu [200.55.140.180]) by mail.postgresql.org (Postfix) with SMTP id 835B7633230 for ; Thu, 12 Nov 2009 08:08:32 -0400 (AST) Received: (qmail 11700 invoked by uid 507); 12 Nov 2009 12:08:23 -0000 Received: from 10.0.0.183 by ns3.uci.cu (envelope-from , uid 501) with qmail-scanner-2.01st (avp: 5.0.2.0. spamassassin: 3.0.6. perlscan: 2.01st. Clear:RC:1(10.0.0.183):. Processed in 0.659924 secs); 12 Nov 2009 12:08:23 -0000 Received: from unknown (HELO ucimail2.uci.cu) (10.0.0.183) by 0 with SMTP; 12 Nov 2009 12:08:22 -0000 Received: from localhost (localhost.localdomain [127.0.0.1]) by ucimail2.uci.cu (Postfix) with ESMTP id 7DD743DC280; Thu, 12 Nov 2009 07:09:37 -0500 (CST) X-Virus-Scanned: amavisd-new at uci.cu Received: from ucimail2.uci.cu ([127.0.0.1]) by localhost (ucimail2.uci.cu [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id N2rhPeGHYDDm; Thu, 12 Nov 2009 07:09:35 -0500 (CST) Received: from [127.0.0.1] (unknown [10.8.46.145]) by ucimail2.uci.cu (Postfix) with ESMTP id F1AD63DC279; Thu, 12 Nov 2009 07:09:34 -0500 (CST) Message-ID: <4AFBA585.60003@uci.cu> Date: Thu, 12 Nov 2009 07:04:53 +0100 From: =?ISO-8859-1?Q?=22Ing_=2E_Marcos_Lu=EDs_Ort=EDz_Valmaseda?= =?ISO-8859-1?Q?=22?= User-Agent: Thunderbird 2.0.0.21 (Windows/20090302) MIME-Version: 1.0 To: Brahma Prakash Tiwari CC: pgsql-performance@postgresql.org, pgsql-jobs@postgresql.org Subject: Re: Why age (datfrozenxid) in postgres becomes 1073742202 not zero after each vacuum of database. References: <20091112082006.416DD1D1445@quasar.inventum.in> In-Reply-To: <20091112082006.416DD1D1445@quasar.inventum.in> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.329 tagged_above=-10 required=5 tests=BAYES_20=-0.74, DATE_IN_PAST_06_12=1.069 X-Spam-Level: X-Archive-Number: 200911/5 X-Sequence-Number: 572 Brahma Prakash Tiwari escribió: > > *Hi all* > > *Why age (datfrozenxid) in postgres becomes 1073742202 not zero after > vacuum of database.* > > *Thanks in advance * > > > > **Brahma Prakash Tiwari**** ** > > DBA > > ------------------------------------------------------------------------ > > **Think before you print.|Go green** > > > This is not the right list for that. Send the message to pgsql-users@postgresql.org or another. This list is for the related jobs with PostgreSQL. Regards -- -- "For me, the purpose is, at least partly, to have joy. Programmers often feel joy when they can concentrate on the creative side of programming, so Ruby is designed to make programmers happy." Yukihiro Matsumoto (Matz), Creator of the Ruby Language Ing. Marcos Luís Ortíz Valmaseda System DBA && Rails New User Centro de Tecnologías de Almacenamiento y Anális de Datos (CENTALAD) Universidad de las Ciencias Informáticas Linux User # 418229 http://www.freebsd.org http://www.postgresql-es.org http://www.postgresql.org http://www.planetpostgresql.org http://www.rubyonrails.org http://www.ruby-lang.org