CYBERTEC PostgreSQL Blog

Visit cybertec-postgresql.com → On Hacker News May 2018 – Nov 2025

2023243 points206 commentscited by 3Databases & Data details

Understand how using UUIDs as primary keys can affect PostgreSQL performance, and how to tweak your index to avoid UUID performance pitfalls.

Get to know and learn how to use some less-known features of Version 12 of PostgreSQL. You'll surely discover something new for yourself.

See how PostgreSQL 19 speeds up aggregations by aggregating before joins, with a benchmark showing over 5x faster execution.

UPDATED July 2023: How to use EXPLAIN ANALYZE in PostgreSQL, learn tools to visualize the output. See query execution time and row count.

Column order can determine how quickly your data is processed in PostgreSQL. Find out how to troubleshoot performance problems in wide tables

How to decide what to use for autogenerated primary keys: UUID, serial or identity column? Recommendations are given!

This article describes how PostgreSQL v14 reduces B-tree index bloat with "bottom-up index tuple deletion". A test case shows the difference.

This article gives a simple introduction with examples to recursive queries in PostgreSQL. It also includes a comparison to Oracle recursive queries.

count(*) is often quite slow in PostgreSQL. This article explores how to count rows faster using approximations and other tricks.

OR in the WHERE condition of a PostgreSQL database query is usually a cause of bad query performance. How to rewrite queries without OR.

Multiranges are a new feature in PostgreSQL 14. Here's a brief introduction on how to use them - learn the basics & important new uses.

PostgreSQL trigger performance. Should we use tiggers at all? Find out how triggers perform in performance tests.