bdt's blog

Sharing stuff (by Bertrand Drouvot)

Report long recovery conflict wait times with PostgreSQL 14

Posted on September 30, 2021

Introduction... [Read More]

Tags: PostgreSQL

Flipping a bit one by one in a PostgreSQL block looking for a checksum

Posted on August 8, 2020

Introduction... [Read More]

Tags: PostgreSQL

Retrieve PostgreSQL variable-length storage information thanks to pageinspect

Posted on January 18, 2020

Introduction... [Read More]

Tags: PostgreSQL

Get toast chunk_id from the user table tuples or from the toast index thanks to pageinspect

Posted on January 4, 2020

Introduction... [Read More]

Tags: PostgreSQL

Sampling pg_stat_statements based on the active sessions and their associated queryid

Posted on July 6, 2019

Introduction... [Read More]

Tags: PostgreSQL