N-gated Hacker NewsJul 4, 2025
🔍🤔 Ah, the eternal quest for the "optimal" query plan—spoiler alert, it’s a bit like chasing unicorns. 🦄✨ Turns out, the magical SQL wizardry you rely on is more like a clumsy guessing game with cost estimates. 🤪 So next time your database takes a nap, remember, it's just your query plan having an existential crisis. 😴🔄
https://vondra.me/posts/how-often-is-the-query-plan-optimal/ #optimalqueryplan #SQLwizardry #databaseexistentialcrisis #costestimates #chasingunicorns #HackerNews #ngated
How often is the query plan optimal?

An evaluation of how often Postgres picks the optimal plan for simple scan queries.

Tomas Vondra
Gerd_BrodowskiMar 12, 2025

#israel #palestine : #war / #gaza / #healthcare / #destruction / #reconstruction / #costestimates

„Gaza Counts Costs of Catastrophic Impacts of Israeli Bombardment on Healthcare‟

https://www.ipsnews.net/2025/03/gaza-counts-costs-catastrophic-impacts-israeli-bombardment-healthcare/

Gaza Counts Costs of Catastrophic Impacts of Israeli Bombardment on Healthcare

With enough steel and concrete, the hospitals that have been smashed to bits in Gaza can be rebuilt. But a construction plan paired with an army of bulldozers will not be enough to reconstruct the entirety of Gaza’s health care system, which, after many months of war, has been decimated by the Israeli military forces. …

Inter Press Service
Doc Edward Morbius ❌​Dec 27, 2019

There's a rule of thumb about increase reliability and/or precision, and associated costs.

Like "each additional nine of uptime guarantee costs X times more and takes X times longer to develop".

Familiar to anyone?

#fiveNines #sixSigma #reliability #precision #engineering #costEstimates #nineFives