Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 9F8CB6321B4 for ; Sun, 22 Aug 2010 12:24:06 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 86743-06 for ; Sun, 22 Aug 2010 15:23:59 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by mail.postgresql.org (Postfix) with ESMTP id 707B26320CC for ; Sun, 22 Aug 2010 12:23:59 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id o7MFNfda015871; Sun, 22 Aug 2010 11:23:41 -0400 (EDT) To: Bruce Momjian cc: Josh Berkus , PostgreSQL-development Subject: Re: Return of the Solaris vacuum polling problem -- anyone remember this? In-reply-to: <201008220240.o7M2eC728013@momjian.us> References: <201008220240.o7M2eC728013@momjian.us> Comments: In-reply-to Bruce Momjian message dated "Sat, 21 Aug 2010 22:40:12 -0400" Date: Sun, 22 Aug 2010 11:23:41 -0400 Message-ID: <15870.1282490621@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.91 tagged_above=-5 required=5 tests=BAYES_00=-1.9, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201008/1600 X-Sequence-Number: 168403 Bruce Momjian writes: > We often mention that we do vacuum freeze for anti-wraparound vacuum, > but not for pg_clog file removal, which is the primary trigger for > autovacuum vacuum freezing. I have added the attached documentation > patch for autovacuum_freeze_max_age; back-patched to 9.0. This patch does not actually seem like an improvement. The paragraph is all about transaction age, but you've inserted something entirely unrelated, and not only that but chosen to make the unrelated thing seem like the major consequence and anti-wraparound an afterthought. regards, tom lane