From the archive
Saturday, 14 November
Folded from 8 sources that day.
Sorted by quality and by how many sources covered it, the same for everyone.
-
How to Reduce PostgreSQL Memory Usage and Cut Your Cloud Bill
One connection pooler setting lowered a customer's PostgreSQL memory use from 93% to 50% and cut the monthly cloud bill from $630 to $320.
-
Pricing plans in PostgreSQL's currency: pg_orca's PG-aligned cost model
Describes how pg_orca replaces ORCA's Greenplum-calibrated cost model with a port of PostgreSQL's costsize.c and maps ORCA's costs onto PostgreSQL's startup costs and loop counts, keeping both within 2%.