Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-hackers-owner+M272794=pgsql-hackers-arkari@postgresql.org>)
 id 1YqqBT-00011w-HB
 for pgsql-hackers@arkaria.postgresql.org; Fri, 08 May 2015 21:51:51 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.80) (envelope-from
 <pgsql-hackers-owner+M272794=pgsql-hackers-arkari@postgresql.org>)
 id 1YqqBT-0005Qj-1E
 for pgsql-hackers@arkaria.postgresql.org; Fri, 08 May 2015 21:51:51 +0000
Received: from makus.postgresql.org ([2001:4800:1501:1::229])
 by malur.postgresql.org with esmtps (TLS1.2:RSA_AES_256_CBC_SHA256:256)
 (Exim 4.80) (envelope-from <tgl@sss.pgh.pa.us>) id 1YqqBS-0005Qd-4n
 for pgsql-hackers@postgresql.org; Fri, 08 May 2015 21:51:50 +0000
Received: from sss.pgh.pa.us ([66.207.139.130])
 by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
 (Exim 4.84) (envelope-from <tgl@sss.pgh.pa.us>) id 1YqqBP-0007A7-EV
 for pgsql-hackers@postgresql.org; Fri, 08 May 2015 21:51:48 +0000
Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1])
 by sss.pgh.pa.us (8.14.4/8.14.4) with ESMTP id t48LpRcL023550;
 Fri, 8 May 2015 17:51:27 -0400
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Andres Freund <andres@anarazel.de>
cc: Stephen Frost <sfrost@snowman.net>, Peter Geoghegan <pg@heroku.com>,
 Heikki Linnakangas <hlinnaka@iki.fi>, Jeff Janes <jeff.janes@gmail.com>,
 Dean Rasheed <dean.a.rasheed@gmail.com>, Bruce Momjian <bruce@momjian.us>,
 Pg Hackers <pgsql-hackers@postgresql.org>
Subject: Re: INSERT ... ON CONFLICT UPDATE/IGNORE 4.0
In-reply-to: <20150508211339.GY12950@alap3.anarazel.de>
References: <20150508181445.GS12950@alap3.anarazel.de>
 <17473.1431109846@sss.pgh.pa.us> <20150508183504.GU12950@alap3.anarazel.de>
 <18313.1431111562@sss.pgh.pa.us>
 <CAM3SWZSqDaRG9c12XewsKqFLkNAak1kxie3UZ6+Wi9cC2UKT8g@mail.gmail.com>
 <18691.1431112058@sss.pgh.pa.us> <18911.1431112384@sss.pgh.pa.us>
 <20150508191600.GA30322@tamriel.snowman.net> <19213.1431112929@sss.pgh.pa.us>
 <20150508202947.GX12950@alap3.anarazel.de>
 <20150508211339.GY12950@alap3.anarazel.de>
Comments: In-reply-to Andres Freund <andres@anarazel.de>
 message dated "Fri, 08 May 2015 23:13:39 +0200"
Date: Fri, 08 May 2015 17:51:27 -0400
Message-ID: <23549.1431121887@sss.pgh.pa.us>
X-Pg-Spam-Score: -0.4 (/)
List-Archive: <http://archives.postgresql.org/pgsql-hackers>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-hackers.postgresql.org>
List-Owner: <mailto:pgsql-hackers-owner@postgresql.org>
List-Post: <mailto:pgsql-hackers@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-hackers>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-hackers>
X-Mailing-List: pgsql-hackers
Precedence: bulk
Sender: pgsql-hackers-owner@postgresql.org

Andres Freund <andres@anarazel.de> writes:
> prairiedog, without CCA, failed as well
> http://pgbuildfarm.org/cgi-bin/show_log.pl?nm=prairiedog&dt=2015-05-08%2019%3A55%3A11
> different test, but again directly after index creation. So I hope it's
> indeed the indcheckxmin thing.

Oh, interesting.  That definitely suggests it's about machine speed/timing
not CCA per se (prairiedog being quite slow).  Which would fit with the
indcheckxmin theory.

			regards, tom lane


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers