Re: Performance bug in prepared statement binding in 9.2?

From: Andres Freund <andres(at)2ndquadrant(dot)com>
To: Andrew Dunstan <andrew(at)dunslane(dot)net>
Cc: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>, Josh Berkus <josh(at)agliodbs(dot)com>, Amit Kapila <amit(dot)kapila(at)huawei(dot)com>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Performance bug in prepared statement binding in 9.2?
Date: 2013-09-10 13:23:17
Message-ID: 20130910132317.GK1024477@alap2.anarazel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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...

Greetings,

Andres Freund

--
Andres Freund http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Andrew Dunstan 2013-09-10 13:41:48 Re: Performance bug in prepared statement binding in 9.2?
Previous Message Andres Freund 2013-09-10 13:21:33 Re: Performance bug in prepared statement binding in 9.2?