Turns out RelationGetNumberOfBlocksInFork is an expensive call. Luckily, it's not needed since ReadBufferExtended will throw an error if the block number is out of range.
without pq
before build time: 360s
after build time: 267s
with pq
before build time: 925s
after build time: 745s
Turns out RelationGetNumberOfBlocksInFork is an expensive call. Luckily, it's not needed since ReadBufferExtended will throw an error if the block number is out of range.
without pq before build time: 360s after build time: 267s
with pq before build time: 925s after build time: 745s