Horton

Re: Parallel Index Scan vs BTP_DELETED and BTP_HALF_DEAD

Robert Haas <robertmhaas@gmail.com>

View thread View on postgr.es
From: Robert Haas <robertmhaas@gmail.com>
To: Kuntal Ghosh <kuntalghosh.2007@gmail.com>
Cc: Amit Kapila <amit.kapila16@gmail.com>, Thomas Munro <thomas.munro@enterprisedb.com>, Pg Hackers <pgsql-hackers@postgresql.org>
Date: 2017-12-13T21:21:59Z
Lists: pgsql-hackers 
On Wed, Dec 13, 2017 at 12:35 AM, Kuntal Ghosh
<kuntalghosh.2007@gmail.com> wrote:
> I've also verified the backward scan case with the query provided by
> Thomas. In standby,
> 2. explain analyze select * from t1 where a+1>a order by a desc; and
> the parallel workers hang.
> The patch fixes the issue.

Committed and back-patched to v10.

Sorry, Kuntal, I forgot to credit you in the commit message.  :-(

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

Commits

  1. Fix parallel index scan hang with deleted or half-dead pages.