From: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> |
---|---|
To: | Andres Freund <andres(at)2ndquadrant(dot)com> |
Cc: | levertond(at)googlemail(dot)com, pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: BUG #8273: Assertion failure in 9.3 beta2 with serializable and savepoints |
Date: | 2013-07-19 21:29:03 |
Message-ID: | 20130719212903.GF4130@eldon.alvh.no-ip.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Andres Freund wrote:
> On 2013-07-19 13:46:44 -0400, Alvaro Herrera wrote:
> > Sadly, this has performance implications, because what previously was
> > just an in-place check of bit flags has now become a function call.
>
> Well, the impact imo primarily comes from actually resolving the
> multixact, not from the function call itself... But I don't think we
> need to overly worried. That path is only entered if xmin is
> in-progress, so that shouldn't have too big implications.
What I am worried about is those code paths that previously executed all
this only by going through straight code in the visibility routine,
without calling any other functions, for the cases where there's no
multixact involved at all. If we introduce function calls here, that
would cause a performance regression for everybody. Of course, people
who benefit from the new multixacts can be happy that they don't block
waiting for a remote transaction, but this doesn't help people who don't
benefit from multixacts.
--
Álvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2013-07-20 00:06:57 | Re: BUG #8273: Assertion failure in 9.3 beta2 with serializable and savepoints |
Previous Message | Andres Freund | 2013-07-19 18:35:16 | Re: BUG #8273: Assertion failure in 9.3 beta2 with serializable and savepoints |