X-Original-To: pgsql-hackers-postgresql.org@postgresql.org Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 2D8619FB1E0 for ; Thu, 14 Sep 2006 08:06:15 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 34154-08 for ; Thu, 14 Sep 2006 11:06:06 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from localhost.localdomain (unknown [62.232.55.118]) by postgresql.org (Postfix) with ESMTP id 907CE9FA2E6 for ; Thu, 14 Sep 2006 08:06:06 -0300 (ADT) Received: from localhost ([127.0.0.1] helo=localhost.localdomain) by localhost.localdomain with esmtp (Exim 4.62) (envelope-from ) id 1GNp2X-0005tC-2H; Thu, 14 Sep 2006 12:05:53 +0100 From: Gregory Stark To: Tom Lane Cc: Alvaro Herrera , ITAGAKI Takahiro , Bruce Momjian , pgsql-hackers@postgresql.org Subject: Re: CSStorm occurred again by postgreSQL8.2 In-Reply-To: <22080.1158198335@sss.pgh.pa.us> (Tom Lane's message of "Wed, 13 Sep 2006 21:45:35 -0400") Organization: EnterpriseDB References: <20060808110913.50FA.ITAGAKI.TAKAHIRO@oss.ntt.co.jp> <200608260346.k7Q3k2g06954@momjian.us> <20060828181312.5638.ITAGAKI.TAKAHIRO@oss.ntt.co.jp> <13251.1157299738@sss.pgh.pa.us> <22080.1158198335@sss.pgh.pa.us> X-Draft-From: ("nnimap+webmail.enterprisedb.com:Inbox" 2508) Date: Thu, 14 Sep 2006 12:05:52 +0100 Message-ID: <87mz92so6n.fsf@enterprisedb.com> User-Agent: Gnus/5.110006 (No Gnus v0.6) Emacs/22.0.50 (gnu/linux) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200609/1092 X-Sequence-Number: 90621 Tom Lane writes: > Anyway, given that there's this one nonobvious gotcha, there might be > others. My recommendation is that we take this off the open-items list > for 8.2 and revisit it in the 8.3 cycle when there's more time. I wonder if Theo's recent reported problem with 4.3M child xids changes the calculus on this. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com