X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 5B882565BE for ; Fri, 11 Mar 2005 10:06:33 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 69672-05 for ; Fri, 11 Mar 2005 10:06:24 +0000 (GMT) Received: from mail.securax.org (mail.securax.org [212.123.25.145]) by svr1.postgresql.org (Postfix) with SMTP id 71062565C2 for ; Fri, 11 Mar 2005 10:06:14 +0000 (GMT) Received: (qmail 1148 invoked by uid 2077); 11 Mar 2005 10:02:46 -0000 Received: from scx (HELO ?10.3.3.12?) (milen@securax.org@scx) by mail.securax.org with SMTP; 11 Mar 2005 10:02:46 -0000 Message-ID: <42316D98.9030507@securax.org> Date: Fri, 11 Mar 2005 12:06:16 +0200 From: "Milen A. Radev" User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Tom Lane Cc: Michael Fuhr , pgsql-admin@postgresql.org Subject: Re: Too frequent warnings for wraparound failure References: <42301107.6010901@securax.org> <20050310155734.GA86004@winnie.fuhr.org> <423079B3.8050601@securax.org> <15917.1110474897@sss.pgh.pa.us> In-Reply-To: <15917.1110474897@sss.pgh.pa.us> X-Enigmail-Version: 0.90.1.1 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: text/plain; charset=windows-1251 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.003 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200503/174 X-Sequence-Number: 16672 -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Tom Lane wrote: > "Milen A. Radev" writes: > >>Two queries - 2 seconds apart: > > >>template1=# SELECT datname, age(datfrozenxid) FROM pg_database; >> datname | age >>- -----------+------------- >> xxx1 | 1519763573 > > >>template1=# SELECT datname, age(datfrozenxid) FROM pg_database; >> datname | age >>- -----------+------------- >> xxx1 | 1519769620 > > > So you managed to execute about 6000 transactions in those two seconds. > Doing what? > > regards, tom lane Well that could be the problem - I'm 99.99% positive we do not execute so many transactions - may be 30-40 thousand per day and that's only for one relatively busy DB. The example database ("xxx1") you've chosen is not used at all. As most of the other databases in that cluster. And another observation (closely related IMO): when I login on another development server/cluster and execute the same query I get an increment for every database for every query execution. But there the version is 8.0.1. - -- Milen A. Radev -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.0 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFCMW2YqGlhYx0/sboRAvO3AJ9PAaADiX2Ci9iChyNCpojFb5uvwgCgnJ99 mzTydVpBaMCp/hJjrUvuO5Q= =OKGe -----END PGP SIGNATURE-----