bdt's blog

Sharing stuff (by Bertrand Drouvot)

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

Active Session History in PostgreSQL: blocker and wait chain

Posted on September 1, 2018

While... [Read More]

Tags: PostgreSQL