PinnedAutovacuum 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 13, 20245Oct 13, 20245
PinnedOracle to Postgres : Happily Ever After editionOracle to Postgres migration challenges after going liveJun 17, 2024633Jun 17, 2024633
PostgreSQL Compatibility Index: The Fellowship of the DatabaseIn the mystical realm of databases, a new hero rises every few moons — a shiny, next-gen PostgreSQL derivative, boldly claiming to be…Dec 10, 202412Dec 10, 202412
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 28, 2024Oct 28, 2024
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 24, 20242Sep 24, 20242
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 12, 202410Sep 12, 202410
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 5, 20243Jul 5, 20243
“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 22, 20243Jun 22, 20243
Oracle to Postgres : The Database DarwinismThe launch of Oracle Autonomous Database sparked a debate about the future of the database administrator (DBA) role. In Oracle…Feb 13, 20231Feb 13, 20231
Published inDevOps.devPostgresql and The Strong Anthropic Principle.I am reminded of the strong anthropic principle in cosmology. The strong anthropic principle says the Universe has these conditions because…Jan 31, 20235Jan 31, 20235
In Patroni We TrustIt’s a funny incident, that occurred in a test environment. We were upgrading the Patroni version from 1.x.x to 2.x.x on all self-hosted…Jan 29, 20232Jan 29, 20232
The Eleph…err…Autovacuum in the room.A few blogs ago, I argued that the autovacuum is the most hardworking employee of the company. At the same time, I complained about…Jan 27, 20231Jan 27, 20231
A noisy neighbor in the cloudA RDS database experienced a strange issue where CPU credit was being drained. It was a burstable T3 medium instance.Dec 7, 2022Dec 7, 2022
Data-Pipeline plumbingHistorically DBAs have accepted the role of default blame acceptor. However, sometimes you need to get dirty with code and perform plumbing…Oct 26, 20226Oct 26, 20226