Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 10E2E9F966E for ; Fri, 31 Aug 2007 16:48:52 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 83085-04 for ; Fri, 31 Aug 2007 16:48:46 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 5D7F59F9643 for ; Fri, 31 Aug 2007 16:48:48 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.1/8.14.1) with ESMTP id l7VJmh1T000816; Fri, 31 Aug 2007 15:48:43 -0400 (EDT) To: Erik Jones cc: Alvaro Herrera , Mikko Partio , Pallav Kalva , pgsql-performance@postgresql.org Subject: Re: 8.2 Autovacuum BUG ? In-reply-to: <127CA85E-A8A0-45D0-9368-4474ED6C99BD@myemma.com> References: <46D83427.60001@livedatagroup.com> <25038.1188574775@sss.pgh.pa.us> <46D83C50.3040409@livedatagroup.com> <20070831161158.GD8046@alvh.no-ip.org> <2ca799770708311131r5ae5e3eera66a7cea1fc5917d@mail.gmail.com> <20070831184744.GK8046@alvh.no-ip.org> <247.1188587325@sss.pgh.pa.us> <127CA85E-A8A0-45D0-9368-4474ED6C99BD@myemma.com> Comments: In-reply-to Erik Jones message dated "Fri, 31 Aug 2007 14:35:49 -0500" Date: Fri, 31 Aug 2007 15:48:43 -0400 Message-ID: <815.1188589723@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/410 X-Sequence-Number: 26540 Erik Jones writes: > On Aug 31, 2007, at 2:08 PM, Tom Lane wrote: >> It's worth noting that the patch Florian is working on, to suppress >> assignment of XIDs for transactions that never write anything, will make >> for a large reduction in the rate of XID consumption in many real-world >> applications. > Off topic and just out of curiousity, is this the work that will > allow standby servers to have selects run on them without stopping > WAL replay? It's a small component of that. regards, tom lane