Re: BUG #1331: after update: vacuum blocks parallel to select - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #1331: after update: vacuum blocks parallel to select
Date
Msg-id 19023.1101745634@sss.pgh.pa.us
Whole thread Raw
In response to BUG #1331: after update: vacuum blocks parallel to select  ("PostgreSQL Bugs List" <pgsql-bugs@postgresql.org>)
List pgsql-bugs
"Enke, Michael" <michael.enke@wincor-nixdorf.com> writes:
> But the description says: vacuum can run parallel to selects.
> This is than not true.

Sure it can; but that doesn't mean there is no interlocking at all.

The issue you have is not so much that the select is running as that it
is *not* running, ie, it's stopped on a particular page.  As soon as it
moves off the modified page, the vacuum will be able to make progress.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #1331: after update: vacuum blocks parallel to select
Next
From: Tom Lane
Date:
Subject: Re: BUG #1329: Bug in IF-ELSEIF-ELSE construct