Re: Avoid endless futile table locks in vacuuming. - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Avoid endless futile table locks in vacuuming.
Date
Msg-id 4893.1451425671@sss.pgh.pa.us
Whole thread Raw
In response to Re: Avoid endless futile table locks in vacuuming.  (Jeff Janes <jeff.janes@gmail.com>)
List pgsql-hackers
Jeff Janes <jeff.janes@gmail.com> writes:
> If we are not doing a scan_all and we fail to acquire a clean-up lock on
> the last block, and the last block reports that it needs freezing, then we
> continue on to wait for the clean-up lock. But there is no need, we don't
> really need to freeze the block, and we already know whether it has tuples
> or not without the clean up lock.  Couldn't we just set the flag based on
> hastup, then 'continue'?

Uh, isn't that what my patch is doing?
        regards, tom lane



pgsql-hackers by date:

Previous
From: Thomas Munro
Date:
Subject: Re: Making tab-complete.c easier to maintain
Next
From: Joe Conway
Date:
Subject: Re: exposing pg_controldata and pg_config as functions