Re: reducing the overhead of frequent table locks - now, with WIP patch - Mailing list pgsql-hackers

From Robert Haas
Subject Re: reducing the overhead of frequent table locks - now, with WIP patch
Date
Msg-id BANLkTinc6QNeJ2ojTzV6VBDFJRSVG2dX=w@mail.gmail.com
Whole thread Raw
In response to reducing the overhead of frequent table locks - now, with WIP patch  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
On Fri, Jun 3, 2011 at 9:17 AM, Robert Haas <robertmhaas@gmail.com> wrote:
> There are numerous problems with the code as it stands at this point.
> It crashes if you try to use 2PC, which means the regression tests
> fail; it probably does horrible things if you run out of shared
> memory; pg_locks knows nothing about the new mechanism (arguably, we
> could leave it that way: only locks that can't possibly be conflicting
> with anything can be taken using this mechanism, but it would be nice
> to fix, I think); and there are likely some other gotchas as well.
> Still, the basic mechanism appears to work.
>
> The code is attached, for anyone who may be curious.  Known idiocies
> are marked with "ZZZ".  The design was discussed on the previous
> thread ("reducing the overhead of frequent table locks"), q.v.  There
> are some comments in the patch as well, but more is likely needed.

Updated patch attached.  This one passes the regression tests, and all
known bugs are fixed.  There are still a few debugging leftovers in
the patch, and probably a few other rough edges, but I think this is
now ready for serious review.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

Attachment

pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Domains versus polymorphic functions, redux
Next
From: Kohei Kaigai
Date:
Subject: [v9.2] Fix leaky-view problem, part 2