| From: | Andrew Dunstan <andrew(at)dunslane(dot)net> |
|---|---|
| To: | Andres Freund <andres(at)2ndquadrant(dot)com> |
| 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:41:48 |
| Message-ID: | 522F219C.4070602@dunslane.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Whittaker | 2013-09-10 15:04:21 | Intermittent hangs with 9.2 |
| Previous Message | Andres Freund | 2013-09-10 13:23:17 | Re: Performance bug in prepared statement binding in 9.2? |