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
