From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-committers(at)postgresql(dot)org |
Subject: | Re: pgsql: Release the exclusive lock on the table early after truncating it |
Date: | 2007-09-12 20:44:03 |
Message-ID: | 20070912204403.GA6671@alvh.no-ip.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-committers |
Tom Lane wrote:
> alvherre(at)postgresql(dot)org (Alvaro Herrera) writes:
> > Release the exclusive lock on the table early after truncating it in lazy
> > vacuum, instead of waiting till commit.
>
> Weren't you going to disable vacuum_delay in that stretch of code, too?
I forgot to mention that I had patched this separately. I back-patched
the removal of vacuum_delay all the way to 8.0, but the early release of
the AccessExclusive lock I limited to HEAD.
--
Alvaro Herrera http://www.amazon.com/gp/registry/DXLWNGRJD34J
"The West won the world not by the superiority of its ideas or values
or religion but rather by its superiority in applying organized violence.
Westerners often forget this fact, non-Westerners never do."
(Samuel P. Huntington)
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Dunstan | 2007-09-12 20:49:27 | pgsql: Perform post-escaping encoding validity checks on SQL literals |
Previous Message | Alvaro Herrera | 2007-09-12 20:21:23 | pgsql: Make REINDEX DATABASE silently skip remote temp tables. |