Re: [BUG] Error in BRIN summarization - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: [BUG] Error in BRIN summarization
Date
Msg-id 20200817190758.GA31235@alvherre.pgsql
Whole thread Raw
In response to Re: [BUG] Error in BRIN summarization  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [BUG] Error in BRIN summarization  (Alvaro Herrera <alvherre@2ndquadrant.com>)
List pgsql-hackers
On 2020-Aug-15, Tom Lane wrote:

> hyrax's latest report suggests that this patch has issues under
> CLOBBER_CACHE_ALWAYS:
> 
> https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=hyrax&dt=2020-08-13%2005%3A09%3A58
> 
> Hard to tell whether there's an actual bug there or just test instability,
> but either way it needs to be resolved.

Hmm, the only explanation I can see for this is that autovacuum managed
to summarize the range before the test script did it.  So the solution
would simply be to disable autovacuum for the table across the whole
script.

I'm running the scripts and dependencies to verify that fix, but under
CLOBBER_CACHE_ALWAYS that takes quite a bit.

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



pgsql-hackers by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: Optimising compactify_tuples()
Next
From: Tom Lane
Date:
Subject: Re: run pgindent on a regular basis / scripted manner