PinnedMayur (Do not drink & database)Autovacuum Tuning in The Cloud EraHow often do you hear DBAs vent, “Autovacuum used to fly on bare-metal, but in the cloud, it feels like it’s dragging forever!” Or they…Oct 13Oct 13
PinnedMayur (Do not drink & database)Schrödinger’s Backups: A Lesson in UncertaintyBackups are a lot like Schrödinger’s cat. You think you have them, but when it’s time to check, they might not be what you expect! Even…Sep 12Sep 12
PinnedMayur (Do not drink & database)Oracle to Postgres : Happily Ever After editionOracle to Postgres migration challenges after going liveJun 173Jun 173
PinnedMayur (Do not drink & database)Postgres : Don’t wait, Innovate!It’s a cultural norm for large companies running Oracle to exercise caution and typically upgrade only to what they consider a “stable…Sep 24Sep 24
Mayur (Do not drink & database)Million Table Test ClubOn the InfoSec Exchange forum, a fascinating discussion unfolded around the challenge of creating 1 million tables and measuring TPS — in…Oct 28Oct 28
Mayur (Do not drink & database)The Database Redemption: Escaping the Shawshank of Poor SQLEvery Monday, A financial department’s service piles up a huge backlog of unprocessed events. Developers as usual blamed the poor databaseJul 5Jul 5
Mayur (Do not drink & database)“The Silence of the Queries: A PostgreSQL Thriller”Disclaimer: “All characters and events in this blog — even those based on real people — are entirely fictional. All celebrity voices are…Jun 22Jun 22