Ardent Performance Computing
Search
database
Testing CloudNativePG Preferred Data Durability
This is the third post about running Jepsen against CloudNativePG. Earlier posts: First: shout out to whoever first came up with Oracle Data Guard Protection Modes. Designing it to be explained as a choice between performance, availability and protection was a great idea. Yesterday’s blog post described how the core of all data safety is copies of …Continue reading→
Data Safety on a Budget
Many experienced DBAs joke that you can boil down the entire job to a single rule of thumb: Don’t lose your data. It’s simple, memorable, and absolutely true – albeit a little oversimplified. Mark Porter’s Cultural Hint “The Onion of our Requirements” conveys the same idea with a lot more accuracy: We need to always make sure we …Continue reading→
Losing Data is Harder Than I Expected
This is a follow‑up to the last article: Run Jepsen against CloudNativePG to see sync replication prevent data loss. In that post, we set up a Jepsen lab to make data loss visible when synchronous replication was disabled — and to show that enabling synchronous replication prevents it under crash‑induced failovers. Since then, I’ve been …Continue reading→
Run Jepsen against CloudNativePG to see sync replication prevent data loss
Are you in the Pacific Northwest? Want to learn more about topics related to this blog? At 3:15p on Thu Nov 13 in KubeCon Atlanta, I’ll be speaking with Leonardo Cecchi about distributed systems theory applied to standard open source postgres cluster reconfigurations. Jepsen is a testing framework for distributed systems that verifies safety guarantees …Continue reading→
Collation Torture Test versus Debian
Collation torture test results are finally finished and uploaded for Debian.https://github.com/ardentperf/glibc-unicode-sorting The test did not pick up any changes in en_US sort order for either Bullseye or Bookworm 🎉️ Buster has glibc 2.28 so it shows lots of changes – as expected. The postgres wiki had claimed that Jessie(8) to Stretch(9) upgrades were safe. …Continue reading→
Postgres Per-Connection Statistics
I’ve had a wish list for a few years now of observability-related things I’d love to see someday in community/open-source Postgres. A few items from my wish list: As I’ve noted in a few places, there has been slow and steady progress in Postgres over recent years. There’s also plenty of good discussion continuing on …Continue reading→
Challenges of Postgres Containers
Many enterprise workloads are being migrated from commercial databases like Oracle and SQL Server to Postgres, which brings anxiety and challenges for mature operational teams. Learning a new database like Postgres sounds intimidating. In practice, most of the concepts directly transfer from databases like SQL Server and Oracle. Transactions, SQL syntax, explain plans, connection management, …Continue reading→
Good Benchmark Engineers and Postgres Benchmark Week
There are four major components to being a good benchmark engineer: Apparently it’s benchmark week in the Postgres world. I only have two data points but that’s enough for me! First data point: I’m visiting Portland. This Thursday Aug 22, the Portland Postgres Users Group (PDXPUG) is having a meetup where Paul Jungwirth is going …Continue reading→
Default Sort Order in Db2, SQL Server, Oracle & Postgres 17
TLDR: I was starting to think that the best choice of default DB collation (for sort order, comparison, etc) in Postgres might be ICU. But after spending some time reviewing the landscape, I now think that code-point order is the best default DB collation – mirroring Db2 and Oracle – and linguistic sorting can be …Continue reading→
Major Developments in Postgres Extension Discovery and Distribution
PostgreSQL “extensions” are a big part of what makes this database special. The developers building the core Postgres database are amazing. But many people don’t realize just how much of a “data platform” Postgres is (borrowing this phrase from something Craig Kerstiens recently posted online) and just how decentralized the development is for PostgreSQL’s capabilities. …Continue reading→
Disclaimer
This is my personal website. The views expressed here are mine alone and may not reflect the views of my employer.I am currently looking for consulting and/or contracting work in the USA around the oracle database ecosystem.
contact:312-725-9249 orschneider @ ardentperf.com
Enter your email address to receive notifications of new posts by email.
Recent Posts
- Testing CloudNativePG Preferred Data DurabilityOctober 5, 2025
- Data Safety on a BudgetOctober 4, 2025
- Postgres Replication LinksOctober 2, 2025
- Losing Data is Harder Than I ExpectedSeptember 28, 2025
- Run Jepsen against CloudNativePG to see sync replication prevent data lossSeptember 1, 2025
Recent Comments
- Losing Data with PostgreSQL and Jepsen – Curated SQL onLosing Data is Harder Than I Expected
- Luiz Verona onRun Jepsen against CloudNativePG to see sync replication prevent data loss
- Jeremy onGraviton2 versus Graviton4
- Elevarq onGraviton2 versus Graviton4
- Best of Tech #74 - Atol Open Blog onUUID Benchmark War
Ardent Performance Computing