Waiting for Postgres 19: Better planner hints with path generation strategies [video]

Published: 21 hours ago (February 5, 2026 at 10:25 PM EST)

1 min read

Source: Hacker News

Article Information

Article URL: https://www.youtube.com/watch?v=QLb3nhIy2Lc
Comments URL: https://news.ycombinator.com/item?id=46908700
Points: 8
Comments: 0

Reducing row count estimation errors in PostgreSQL

Introduction PostgreSQL's query planner relies on table statistics to estimate the number of rows estimated rows each operation will process, and then selects...

How POSTGRES indexing is more efficient than MYSQL

Problem setup How Index Scan works internally for both DBs Table definition MySQL & PostgreSQL sql CREATE TABLE 'user' id BIGINT PRIMARY KEY, name VARCHAR100,...

The Scaling Gauntlet, Pt. 3: Cache Rules Everything Around Me

It starts, like all false dawns, with good news. Postgres Pete is calm. The team celebrates. Someone makes a meme. But something’s off. Not “the app is down” b...

PostgreSQL Sharding: Scaling Relational Databases

PostgreSQL sharding—splitting data across multiple independent nodes—offers a path to linear scalability, lower latency, and fault isolation. However, it introd...

Article Information

Related posts

Reducing row count estimation errors in PostgreSQL

How POSTGRES indexing is more efficient than MYSQL

The Scaling Gauntlet, Pt. 3: Cache Rules Everything Around Me

PostgreSQL Sharding: Scaling Relational Databases