Jianghua yang: Pricing plans in PostgreSQL's currency: pg_orca's PG-aligned cost model

Planet PostgreSQL2026-11-14 08:000 views

How pg_orca replaced ORCA's Greenplum-calibrated cost model with a port of PostgreSQL's costsize.c: where it plugs in, how it bridges ORCA's total-only costs and rebinds to PostgreSQL's startup costs and loop counts, and how a regression harness keeps both planners within 2%.

Source：https://postgr.es/p/9BP

My favorites

PreviousI tested 12 new fitness trackers this year — but I'd only buy 2 on Black Friday NextClaude Fable 5.2 vs. Fable 5.1: Fewer refusals, with small savings on the login fix

You wrote WHERE status = NULL, and the query came back empty

Checked against official sources on November 13, 2026 You have a table of tickets. Some rows have no status yet. You wan

0dev.to Database

notes on learning the streaming side of the warehouse

thesis i am struggling through debezium and kafka configuration right now, including heartbeat settings that are harder

0dev.to Database

PostgreSQL

Auto Generate? In PostgreSQL, Auto Generate usually means automatically generating values for a column, such as an ID. Y

0dev.to Database

SQLite for Beginners: The Tiny Database Inside Every Phone, Browser, and App

SQLite is the most widely used database in the world — and most people have never heard of it. It lives inside every And

0dev.to Database

How to check how much RAM your Linux VPS really uses: free, available memory, the page cache and the OOM killer

Most people who think their VPS is "out of RAM" are looking at the wrong number. Linux fills spare memory with disk cach

0dev.to Linux

A practical guide to race conditions and five ways engineers make sure it's never both

Two Travellers, One Hotel Room, the Same Second: Who Gets It? Sofia is in Madrid. James is in Toronto. Both are planning

0dev.to Docker

Jianghua yang: Pricing plans in PostgreSQL's currency: pg_orca's PG-aligned cost model

Related posts

You wrote WHERE status = NULL, and the query came back empty

notes on learning the streaming side of the warehouse

PostgreSQL

SQLite for Beginners: The Tiny Database Inside Every Phone, Browser, and App

How to check how much RAM your Linux VPS really uses: free, available memory, the page cache and the OOM killer

A practical guide to race conditions and five ways engineers make sure it's never both