Re: BUG #8273: Assertion failure in 9.3 beta2 with serializable and savepoints - Mailing list pgsql-bugs

From Alvaro Herrera
Subject Re: BUG #8273: Assertion failure in 9.3 beta2 with serializable and savepoints
Date
Msg-id 20130720000657.GI4130@eldon.alvh.no-ip.org
Whole thread Raw
In response to Re: BUG #8273: Assertion failure in 9.3 beta2 with serializable and savepoints  (Andres Freund <andres@2ndquadrant.com>)
List 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.

True.  I have pushed it, with this tweak:

> > Perhaps it'd be smart to optimize it a bit so that we first check the
> > flags, and only call the function if that fails.
>
> Sounds like a good idea to me. The duplicated amount of work by that
> should by fairly minimal.

Thanks.

--
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services

pgsql-bugs by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: BUG #8273: Assertion failure in 9.3 beta2 with serializable and savepoints
Next
From: Sandeep Thakkar
Date:
Subject: Re: Installer: Spurious "service account ... not removed" on uninstall