Re: [Proposal] Fully WAL logged CREATE DATABASE - No Checkpoints

Hi,

On August 4, 2022 4:20:16 PM PDT, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>Yeah, the assumption that P_NEW would automatically match the source block
>was making me itchy too.  An explicit test-and-elog seems worth the
>cycles.

Is there a good reason to rely on P_NEW at all? Both from an efficiency and robustness POV it seems like it'd be better
touse smgrextend to bulk extend just after smgrcreate() and then fill s_b u using RBM_ZERO (or whatever it is called).
Thatbulk smgrextend would later be a good point to use fallocate so the FS can immediately size the file correctly,
withouta lot of pointless writes of zeroes.  

Andres
--
Sent from my Android device with K-9 Mail. Please excuse my brevity.