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
Simple Anomaly Detection Using Plain SQL
Identify Problems Before They Become Disasters
3
Some SQL Tricks of an Application DBA
Non-trivial tips for database development
4
Fast Way to Load Data into PostgreSQL Using Python
From two minutes to less than half a second!
5
The many faces of DISTINCT in Postgres (2017)
3 interesting uses of DISTINCT in PostgreSQL
6
Common Mistakes and Missed Optimization Opportunities in SQL
Made by Developers and Non-Developers
7
How to Get or Create in PostgreSQL
And why it is so easy to get wrong...