Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Yqnbu-0002y8-6c for pgsql-hackers@arkaria.postgresql.org; Fri, 08 May 2015 19:06:58 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1Yqnbt-0003VH-M9 for pgsql-hackers@arkaria.postgresql.org; Fri, 08 May 2015 19:06:57 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1Yqnbr-0003TG-Th for pgsql-hackers@postgresql.org; Fri, 08 May 2015 19:06:55 +0000 Received: from tamriel.snowman.net ([2001:4830:167b::11]) by magus.postgresql.org with esmtp (Exim 4.84) (envelope-from ) id 1Yqnbp-00045P-47 for pgsql-hackers@postgresql.org; Fri, 08 May 2015 19:06:55 +0000 Received: by tamriel.snowman.net (Postfix, from userid 1000) id C944F5F7AF; Fri, 8 May 2015 15:06:50 -0400 (EDT) Date: Fri, 8 May 2015 15:06:50 -0400 From: Stephen Frost To: Peter Geoghegan Cc: Tom Lane , Andres Freund , Heikki Linnakangas , Jeff Janes , Dean Rasheed , Bruce Momjian , Pg Hackers Subject: Re: INSERT ... ON CONFLICT UPDATE/IGNORE 4.0 Message-ID: <20150508190650.GY30322@tamriel.snowman.net> References: <10633.1431105922@sss.pgh.pa.us> <554CF44B.3080808@iki.fi> <20150508180636.GR12950@alap3.anarazel.de> <20150508181445.GS12950@alap3.anarazel.de> <17473.1431109846@sss.pgh.pa.us> <20150508183504.GU12950@alap3.anarazel.de> <18313.1431111562@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="aGy1ZVL4smgYfhap" Content-Disposition: inline In-Reply-To: X-Editor: Vim http://www.vim.org/ X-Info: http://www.snowman.net X-Operating-System: Linux/3.13.0-46-generic (x86_64) X-Uptime: 15:06:05 up 50 days, 54 min, 6 users, load average: 0.00, 0.07, 0.12 User-Agent: Mutt/1.5.21 (2010-09-15) X-Pg-Spam-Score: -0.4 (/) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-hackers Precedence: bulk Sender: pgsql-hackers-owner@postgresql.org --aGy1ZVL4smgYfhap Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable * Peter Geoghegan (pg@heroku.com) wrote: > On Fri, May 8, 2015 at 12:00 PM, Peter Geoghegan wrote: > > On Fri, May 8, 2015 at 11:59 AM, Tom Lane wrote: > >> Ooops. But shouldn't that have failed 100% of the time in a CCA build? > >> Or is the candidates list fairly noncritical? > > > > The candidates list is absolutely critical. >=20 > However, the problematic code path is only a couple of times in the > regression test. To Tom's point, it shouldn't actually matter how many times it's in the regression test, should it? I'm not saying you're wrong about the cause, but it's certainly interesting that it didn't consistently blow up with CCA.. Thanks! Stephen --aGy1ZVL4smgYfhap Content-Type: application/pgp-signature; name="signature.asc" Content-Description: Digital signature -----BEGIN PGP SIGNATURE----- Version: GnuPG v1 iQIcBAEBCgAGBQJVTQlKAAoJEO1sijiDR2RVSVUQAIewlh2GCbosy6ubYKU4nTSL sNtfhjyxnxNzez7hb/xjCYmfZY2MWYIMwM6xB56VKGA4MOGtOaG1wnH7wRz6ssQa dDrhFQROOuNBeAnI73mb8YWbuk9C7EwBHlWievKzHyVG3pVxTDsp8EXti7x3qH7y stviVJEmEvwVxSJ23i2tp7Icv9Wzt0Ax9m9upuDU9jjzXSOaAum+OY6QikgicSmf iXbdWaKAQhXKIhdcVvd8hizwl4N5RIt4vb3PX5e4/bRkoqG9h7nx1iUXjouB3/kM JDsF/Vd07jPzmVxdA3bLyjPQ4TNFV2mygzuNqu8zSHgmLokl58qrW6+7jdc1lYgk o+1KbaVzSL6slOJzBEtnw6wwoD1dlfCMI/zHmK+67x85JJ+x8jMP6tP5rM6nOA0O dvWr2Acot3ijzPmDHEtHODv+NSjyimpicXdMumYsMCa3UFujiVWLgr5PiFx+XZW3 mPrGYtjSVR/8UACj8ryV98I9mqv8tYKUjxsTvI4bFcvoh25qDn8rmKHcOVZNKkI1 o/PxWpCDD9dDCjzGo3hWe7YHvgFDh6bJRTWfT+l4tFhQiD8RJeoh9MYL7mCzfAWF mADnS5NEEq1+OXlg5xfU6avRh4K9rrk/aKRqyis7JX+BWdASoMVCbz9NGSNPcUjg dvjETezB8ovg2EXXfS/G =e0Lc -----END PGP SIGNATURE----- --aGy1ZVL4smgYfhap--