Re: [PATCH] Don't block HOT update by BRIN index - Mailing list pgsql-hackers

From Tomas Vondra
Subject Re: [PATCH] Don't block HOT update by BRIN index
Date
Msg-id b10714af-ab5e-2c10-1786-383dbb1747a4@enterprisedb.com
Whole thread Raw
In response to Re: [PATCH] Don't block HOT update by BRIN index  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On 12/6/21 02:47, Tom Lane wrote:
> Tomas Vondra <tomas.vondra@enterprisedb.com> writes:
>> On 12/5/21 21:16, Tom Lane wrote:
>>> Oh, geez.  *Please* let us not add another regression failure mode
>>> like the ones that afflict stats.sql.  We do not need a doubling
>>> of that failure rate.  I suggest just removing this test.
> 
>> Whooops. Agreed, I'll get rid of that test.
> 
> Another idea, perhaps, is to shove that test into stats.sql,
> where people would know to ignore it?  (Actually, I've thought
> more than once that we should mark stats.sql as ignorable
> in the schedule ...)
> 

Yep. I've moved the test to stats.sql - that seems better than just 
ditching it, because we're experimenting with maybe relaxing the HOT 
rules for BRIN a bit further and not having tests for that would be 
unfortunate.

I haven't marked the test as ignorable. I wonder if we should make that 
customizable, so that some animals (like serinus, which fails because of 
stats.sql from time to time) could run ignore it. But if it fails 
elsewhere it would still be considered a proper failure.

regards
-- 
Tomas Vondra
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



pgsql-hackers by date:

Previous
From: Thomas Munro
Date:
Subject: Re: Add client connection check during the execution of the query
Next
From: Amit Kapila
Date:
Subject: Re: Non-superuser subscription owners