RE: [Patch] Optimize dropping of relation buffers using dlist

k.jamison@fujitsu.com <k.jamison@fujitsu.com>

From: "k.jamison@fujitsu.com" <k.jamison@fujitsu.com>

To: "k.jamison@fujitsu.com" <k.jamison@fujitsu.com>, "tsunakawa.takay@fujitsu.com" <tsunakawa.takay@fujitsu.com>, 'Amit Kapila' <amit.kapila16@gmail.com>

Cc: Kyotaro Horiguchi <horikyota.ntt@gmail.com>, "tgl@sss.pgh.pa.us" <tgl@sss.pgh.pa.us>, "andres@anarazel.de" <andres@anarazel.de>, "robertmhaas@gmail.com" <robertmhaas@gmail.com>, "tomas.vondra@2ndquadrant.com" <tomas.vondra@2ndquadrant.com>, "pgsql-hackers@postgresql.org" <pgsql-hackers@postgresql.org>

Date: 2020-10-08T09:37:48Z

Lists: pgsql-hackers

Attachments

0001-v1-Prevent-invalidating-blocks-in-smgrextend-during-recovery.patch (application/octet-stream) patch v1-0001
0002-v2-Add-bool-param-in-smgrnblocks-for-cached-blocks.patch (application/octet-stream) patch v2-0002
0003-v23-Optimize-DropRelFileNodeBuffers-during-recovery.patch (application/octet-stream) patch v23-0003

Hi, 
> Attached are the updated patches.

Sorry there was an error in the 3rd patch. So attached is a rebase one.

Regards,
Kirk Jamison

Commits

Fix size overflow in calculation introduced by commits d6ad34f3 and bea449c6.
- 519e4c9ee21a 14.0 landed
Optimize DropRelFileNodesAllBuffers() for recovery.
- bea449c635c0 14.0 landed
Optimize DropRelFileNodeBuffers() for recovery.
- d6ad34f3410f 14.0 landed
Cache smgrnblocks() results in recovery.
- c5315f4f4484 14.0 cited
Add a check to prevent overwriting valid data if smgrnblocks() gives a
- ffae5cc5a602 8.2.0 cited