Re: BUG #8470: 9.3 locking/subtransaction performance regression - Mailing list pgsql-bugs

From Oskari Saarenmaa
Subject Re: BUG #8470: 9.3 locking/subtransaction performance regression
Date
Msg-id 524FC6CC.6050407@ohmu.fi
Whole thread Raw
In response to Re: BUG #8470: 9.3 locking/subtransaction performance regression  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Responses Re: BUG #8470: 9.3 locking/subtransaction performance regression  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Re: BUG #8470: 9.3 locking/subtransaction performance regression  (Alvaro Herrera <alvherre@2ndquadrant.com>)
List pgsql-bugs
05.10.2013 01:31, Alvaro Herrera kirjoitti:
> AFAICS the problem here is that this test doesn't use MultiXactIds at
> all in 9.2, but it does in 9.3.  I vaguely recall Noah tried to convince
> me to put in an optimization which would have avoided this issue; I will
> give that a thought.  I don't think I will be able to get it done for
> 9.3.1 though.

Is the schedule for 9.3.1 visible somewhere?  Please reconsider trying
to get a fix for this in as it's a pretty big regression from 9.2.  My
application test case that triggered this ran in roughly 3 seconds with
9.2 but timed out after 3 minutes on 9.3.0.  And even without a loop
that amplifies this, just a single 'select for update' inside a
subtransaction is significantly slower in 9.3.

Thanks,
Oskari

pgsql-bugs by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: BUG #8470: 9.3 locking/subtransaction performance regression
Next
From: Michael Paquier
Date:
Subject: Re: BUG #8498: pg_trgm is missing from windows edb package