📖Just published "How to Achieve Pruning When Querying by Non-Partitioned Columns in PostgreSQL"
https://hakibenita.com/postgresql-partition-pruning
Most people think pruning can only be achieved when querying by the partition key. However, if your data follows certain patterns, using some clever tricks you can achieve pruning even when filtering by non-partition key columns. In this article I show how ;)
Haki Benita
npub13h…q7kca
2026-07-09 10:57:46 UTC
Author Public Key
npub13hhr0td5zclunctxnl74mq5st6x7r3l7w2ldtz8a50tyndacuvfqpq7kcaPublished at
2026-07-09 10:57:46 UTCEvent JSON
{
"id": "ea42a83a89fd7e5e4f7382bf343a4987d5bc594f97868a3ad44fb1342bb2e1d8",
"pubkey": "8dee37adb4163fc9e1669ffd5d82905e8de1c7fe72bed588fda3d649b7b8e312",
"created_at": 1783594666,
"kind": 1,
"tags": [
[
"proxy",
"https://fosstodon.org/users/be_haki/statuses/116889660093524892",
"activitypub"
],
[
"client",
"Mostr",
"31990:6be38f8c63df7dbf84db7ec4a6e6fbbd8d19dca3b980efad18585c46f04b26f9:mostr",
"wss://relay.ditto.pub"
]
],
"content": "📖Just published \"How to Achieve Pruning When Querying by Non-Partitioned Columns in PostgreSQL\"\n\nhttps://hakibenita.com/postgresql-partition-pruning\n\nMost people think pruning can only be achieved when querying by the partition key. However, if your data follows certain patterns, using some clever tricks you can achieve pruning even when filtering by non-partition key columns. In this article I show how ;)",
"sig": "8dcc75774fabce42a85d61e8f9f1ac9a8c8efb0d8cd3aa5417d81c0c9ea517328f3d2c0971b1352192cee47fdd850cc00ac3465ed772ccfe9bfa560bfc7b93b0"
}