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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
