1
Lesser-known Postgres features
Features you already have but may not know about!
Haki Benita
The writings of Haki Benita
- Popular posts
- 11
- Total points
- 3,846
- HN comments
- 931
- Rank
- #335 personal
Visit hakibenita.com → RSS feedOn Hacker News Jul 2019 – Jan 2026
Databases & Data 11Software Engineering 7Systems & Performance 3Tools & Productivity 1
2
Practical SQL for Data Analysis
What you can do without Pandas
3
Simple Anomaly Detection Using Plain SQL
Identify Problems Before They Become Disasters
4
Unconventional PostgreSQL Optimizations
Creative ideas for speeding up queries in PostgreSQL
5
An unexpected find that freed 20GB of unused index space in PostgreSQL
How to free space without dropping indexes or deleting data
6
Some SQL Tricks of an Application DBA
Non-trivial tips for database development
7
Fast Way to Load Data into PostgreSQL Using Python
From two minutes to less than half a second!
8
The many faces of DISTINCT in Postgres (2017)
3 interesting uses of DISTINCT in PostgreSQL
9
The surprising impact of medium-size texts on PostgreSQL performance
Why TOAST is the best thing since sliced bread
10
Common Mistakes and Missed Optimization Opportunities in SQL
Made by Developers and Non-Developers
11
How to Get or Create in PostgreSQL
And why it is so easy to get wrong...