Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 6C9971337B34 for ; Tue, 1 Mar 2011 16:10:06 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 83065-04-5 for ; Tue, 1 Mar 2011 20:09:58 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from midnight-anchovy.ambulatoryclam.net (unknown [18.141.0.210]) by mail.postgresql.org (Postfix) with ESMTP id 947891337BCD for ; Tue, 1 Mar 2011 16:09:58 -0400 (AST) Received: by midnight-anchovy.ambulatoryclam.net (Postfix, from userid 1001) id 119774AC2B; Tue, 1 Mar 2011 15:09:58 -0500 (EST) Date: Tue, 1 Mar 2011 15:09:58 -0500 From: Dan Ports To: Heikki Linnakangas Cc: PostgreSQL-development Subject: Re: SSI bug? Message-ID: <20110301200957.GA91864@csail.mit.edu> References: <4D616C14020000250003AD9A@gw.wicourts.gov> <20110221234236.4635E19D574@mail.netbsd.org> <20110222024129.GC74913@csail.mit.edu> <4D639519020000250003AE0D@gw.wicourts.gov> <20110222232054.GC61128@csail.mit.edu> <20110301000306.GL10115@csail.mit.edu> <4D6D27DE.8080304@enterprisedb.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <4D6D27DE.8080304@enterprisedb.com> User-Agent: Mutt/1.5.21 (2010-09-15) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.107 tagged_above=-5 required=5 tests=BAYES_00=-1.9, RDNS_NONE=0.793 X-Spam-Level: X-Archive-Number: 201103/67 X-Sequence-Number: 183317 On Tue, Mar 01, 2011 at 07:07:42PM +0200, Heikki Linnakangas wrote: > Was there test cases for any of the issues fixed by this patch that we > should add to the suite? Some of these issues are tricky to test, e.g. some of the code about transferring predicate locks to a new target doesn't get exercised unless an index page gets split while there are concurrent transactions holding locks on that page. I have not been able to find a good way to test these other than system-level testing using a concurrent workload (usually the DBT-2 benchmark). I'd certainly be open to suggestions! Dan -- Dan R. K. Ports MIT CSAIL http://drkp.net/