Oskari Saarenmaa wrote:
Hi,
> I didn't try this patch, but I built today's REL9_3_STABLE with the patch
> from your mail on the 31st of Dec
> (http://github.com/saaros/postgres/tree/alvaro-multixact-optimize-9.3) and
> ran the older version of my appliaction's test suite which has a case that
> times out after 3 minutes with unpatched 9.3. With the current patch the
> test case successfully completes in ~20 seconds which is a major improvement
> although it's still slower than 9.2 It also passes all other test cases in
> my test suite.
>
> Do you think it'll make it to 9.3.3?
I just pushed this to 9.5. I'm not sure how much value I place on a
backpatch at this point. There were a number of complaints about the
performance regression, but other than yours I got no report on whether
the fix was good, or on whether it was stable. If you have other
thoughts, I'm willing to listen. Anyway if you could test the patch I
pushed, it'd be great.
--
Álvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services