Re: GIN data corruption bug(s) in 9.6devel - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: GIN data corruption bug(s) in 9.6devel
Date
Msg-id 20160407222302.GA605634@alvherre.pgsql
Whole thread Raw
In response to Re: GIN data corruption bug(s) in 9.6devel  (Jeff Janes <jeff.janes@gmail.com>)
List pgsql-hackers
Jeff Janes wrote:

> The proposed change removes that throttle, so that inserters will
> immediately see there is already a cleaner and just go back about
> their business.  Due to that, unthrottled backends could add to the
> pending list faster than the cleaner can clean it, leading to
> unbounded growth in the pending list and could cause a user backend to
> becoming apparently unresponsive to the user, indefinitely.  That is
> scary to backpatch.

Can we install a protection against that?  For instance, the cleaner
only cleans up the entries that were present when it started, and if
other items are inserted later into the pending list, they are left for
a future cleaner.

-- 
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services



pgsql-hackers by date:

Previous
From: Jeff Janes
Date:
Subject: Re: GIN data corruption bug(s) in 9.6devel
Next
From: Peter Geoghegan
Date:
Subject: Re: Using quicksort for every external sort run