1
Postgres scaling advice
Planning to scale PostgreSQL? Learn when a single node is enough, how to prepare for sharding, and which scaling steps to consider first.
CYBERTEC PostgreSQL Blog
- Popular posts
- 14
- Total points
- 2,741
- HN comments
- 1,099
- Rank
- #434 company
Visit cybertec-postgresql.com → On Hacker News May 2018 – Nov 2025
Databases & Data 14Software Engineering 12Tools & Productivity 1Infrastructure & DevOps 1
2
Unexpected downsides of UUID keys in PostgreSQL
Understand how using UUIDs as primary keys can affect PostgreSQL performance, and how to tweak your index to avoid UUID performance pitfalls.
3
Discovering less-known Postgres v12 features
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.
4
Super fast aggregations in PostgreSQL 19
See how PostgreSQL 19 speeds up aggregations by aggregating before joins, with a benchmark showing over 5x faster execution.
5
PostgreSQL EXPLAIN Output Explained
UPDATED July 2023: How to use EXPLAIN ANALYZE in PostgreSQL, learn tools to visualize the output. See query execution time and row count.
6
Column order in PostgreSQL does matter
Column order can determine how quickly your data is processed in PostgreSQL. Find out how to troubleshoot performance problems in wide tables
7
UUID, serial or identity columns for PostgreSQL auto-generated primary keys?
How to decide what to use for autogenerated primary keys: UUID, serial or identity column? Recommendations are given!
8
Index bloat reduced in PostgreSQL v14
This article describes how PostgreSQL v14 reduces B-tree index bloat with "bottom-up index tuple deletion". A test case shows the difference.
9
Understanding Recursive Queries in PostgreSQL
This article gives a simple introduction with examples to recursive queries in PostgreSQL. It also includes a comparison to Oracle recursive queries.
10
PostgreSQL Count(*) Performance Improvements
count(*) is often quite slow in PostgreSQL. This article explores how to count rows faster using approximations and other tricks.
11
Avoiding “OR” for Better Query Performance
OR in the WHERE condition of a PostgreSQL database query is usually a cause of bad query performance. How to rewrite queries without OR.
12
Multiranges in Postgres
Multiranges are a new feature in PostgreSQL 14. Here's a brief introduction on how to use them - learn the basics & important new uses.
13
Are triggers really that slow in Postgres?
PostgreSQL trigger performance. Should we use tiggers at all? Find out how triggers perform in performance tests.
14
Getting Started with QGIS, PostgreSQL and PostGIS
Visualizing spatial data is an important task. This tutorial helps you with getting started with visualizing OSM data with PostGIS and QGIS.