Skip to content

Haki Benita personal blog

Unconventional PostgreSQL Optimizations

hakibenita.com published 2026-01-20

Creative ideas for speeding up queries in PostgreSQL

Read on hakibenita.com → Discuss on HN (69) Archived copy

Points: 431
HN comments: 69
Submissions: 1
Cited by: 0 commenters

Databases & Data Systems & Performance 2026

On Hacker News

Submitted	Title on HN	Points	Comments
Jan 20, 2026	Unconventional PostgreSQL Optimizations by haki	431	69

More from Haki Benita

All 11 posts →

Lesser-known Postgres features

2021702 points180 comments Databases & Data details

Practical SQL for Data Analysis

2021602 points191 comments Databases & Data details

Simple Anomaly Detection Using Plain SQL

2021512 points47 comments Databases & Data details

An unexpected find that freed 20GB of unused index space in PostgreSQL

2021375 points140 comments Databases & Data details

Some SQL Tricks of an Application DBA

2020327 points68 comments Databases & Data details

Fast Way to Load Data into PostgreSQL Using Python

2019246 points29 comments Databases & Data details

Related posts from the same era

ICE using Palantir tool that feeds on Medicaid data

EFF Deeplinks20261,475 points969 comments details

Ingesting PDFs and why Gemini 2.0 changes everything

Sergey's Blog20251,303 points447 comments details

Tracking down the 16-year-old WAL-reset SQLite bug

Tailscale Blog20261,223 points239 commentscited by 3 details

Postgres IDE in VS Code

Microsoft Tech Community20251,040 points407 comments details

PGSimCity - How PostgreSQL Works

nikolays.github.io2026930 points90 comments details

The DuckDB Local UI

DuckDB Blog2025926 points188 commentscited by 3 details