Re: [PATCH] Don't block HOT update by BRIN index

Tomas Vondra <tomas.vondra@enterprisedb.com>

View thread

From: Tomas Vondra <tomas.vondra@enterprisedb.com>

To: Josef Šimánek <josef.simanek@gmail.com>

Cc: Alvaro Herrera <alvherre@alvh.no-ip.org>, Pg Hackers <pgsql-hackers@postgresql.org>

Date: 2021-10-04T14:17:47Z

Lists: pgsql-hackers

Attachments

0002-fixes-and-remove-rd_indexattr-20211004.patch (text/x-patch)

Hi,

I took a look at this patch again to see if I can get it polished and 
fixed. Per the discussion, I've removed the rd_indexattr list and 
replaced it with a simple flag. While doing so, I noticed a couple of 
places that should have consider (init or free) rd_hotblockingattr.

Patch 0001 is the v2, 0002 removes the rd_indexattr etc.

regards

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

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

Ignore BRIN indexes when checking for HOT updates
- 19d8e2308bc5 16.0 landed
Move test for BRIN HOT behavior to stats.sql
- fe60b67250a3 15.0 landed
Ignore BRIN indexes when checking for HOT udpates
- 5753d4ee320b 15.0 landed