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

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

I Built Homelab Architect — Plan Your Stack Before You Build It

Most homelab beginners make the same mistake: they grab a Docker Compose template, paste it in, and then discover three

0dev.to Docker

Show HN: Burrmill – SQL over Parquet with exact integer arithmetic

Article URL: https://github.com/nuthatch-org/burrmill Comments URL: https://news.ycombinator.com/item?id=50497375 Points

0Hacker News Show

Metadata Filters for Customer-Support Search — A Retrieval Architecture That Holds Up

Short answer: use staged retrieval with explicit collections, bounded queries, and source context that survives all the

0dev.to

Laravel Slow Query Detection: Catch Them Before Users Do

Series: Every Laravel Project Should Have These Building Blocks Part: 29 of 35 Level: Intermediate Prerequisites: App Se