Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VJOD5-0002gH-PC for pgsql-performance@arkaria.postgresql.org; Tue, 10 Sep 2013 13:42:27 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1VJOD5-0005Y8-4W for pgsql-performance@arkaria.postgresql.org; Tue, 10 Sep 2013 13:42:27 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VJOD3-0005Y1-T4 for pgsql-performance@postgresql.org; Tue, 10 Sep 2013 13:42:26 +0000 Received: from relay5-d.mail.gandi.net ([217.70.183.197]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VJOCs-0003U9-Vp for pgsql-performance@postgresql.org; Tue, 10 Sep 2013 13:42:25 +0000 Received: from mfilter8-d.gandi.net (mfilter8-d.gandi.net [217.70.178.137]) by relay5-d.mail.gandi.net (Postfix) with ESMTP id C172C41C064; Tue, 10 Sep 2013 15:41:52 +0200 (CEST) X-Virus-Scanned: Debian amavisd-new at mfilter8-d.gandi.net Received: from relay5-d.mail.gandi.net ([217.70.183.197]) by mfilter8-d.gandi.net (mfilter8-d.gandi.net [10.0.15.180]) (amavisd-new, port 10024) with ESMTP id zECTJ3YQKSNZ; Tue, 10 Sep 2013 15:41:51 +0200 (CEST) X-Originating-IP: 98.27.58.255 Received: from [192.168.10.146] (cpe-098-027-058-255.nc.res.rr.com [98.27.58.255]) (Authenticated sender: adsend@dunslane.net) by relay5-d.mail.gandi.net (Postfix) with ESMTPSA id 3CB6B41C0B0; Tue, 10 Sep 2013 15:41:50 +0200 (CEST) Message-ID: <522F219C.4070602@dunslane.net> Date: Tue, 10 Sep 2013 09:41:48 -0400 From: Andrew Dunstan User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:17.0) Gecko/20130110 Thunderbird/17.0.2 MIME-Version: 1.0 To: Andres Freund CC: Jeff Janes , Josh Berkus , Amit Kapila , "pgsql-performance@postgresql.org" Subject: Re: Performance bug in prepared statement binding in 9.2? References: <51A699E6.3000008@agliodbs.com> <51A79512.4020200@agliodbs.com> <51FAA1B8.6040809@agliodbs.com> <522E69F1.8070203@dunslane.net> <20130910122036.GF1024477@alap2.anarazel.de> <522F146D.2070908@dunslane.net> <20130910132133.GJ1024477@alap2.anarazel.de> <20130910132317.GK1024477@alap2.anarazel.de> In-Reply-To: <20130910132317.GK1024477@alap2.anarazel.de> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -2.6 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org On 09/10/2013 09:23 AM, Andres Freund wrote: > On 2013-09-10 15:21:33 +0200, Andres Freund wrote: >> If I interpret things correctly you're using serializable? I guess there >> is no chance to use repeatable read instead? > Err, that wouldn't help much. Read committed. That lets PGXACT->xmin advance > these days and thus might help to reduce the impact of the longrunning > transactions. > Otherwise you will have to shorten those... > Yeah, we're looking at eliminating them. cheers andrew -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance