October | 2025 | Ardent Performance Computing
5 posts published by Jeremy during October 2025| Ardent Performance Computing
5 posts published by Jeremy during October 2025| Ardent Performance Computing
A couple times within the past month, I’ve had people send me a message asking if I have any suggestions about where to learn postgres. I like to share the collection of links that I’ve accumulated (and please send me more, if you have good ones!) but another thing I always say is that the … Continue reading →| Ardent Performance Computing
Are you in the Pacific Northwest? Since January 2024 we’ve been recording the presentations at Seattle Postgres User Group. After some light editing and an opportunity for the speaker to take a final pass, we post them to YouTube. I’m perpetually behind (I do the editing myself) so you won’t find the videos from this … Continue reading →| Ardent Performance Computing
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 →| Ardent Performance Computing
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…| Ardent Performance Computing
Our platform team has a regular meeting where we often use ops issues as a springboard to dig into Postgres internals. Great meeting today – we ended up talking about the internal architecture of Postgres replication. Sharing a few high-quality links from our discussion: Alexander Kukushkin’s conference talk earlier this year, which includes a great … Continue reading →| Ardent Performance Computing
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 …| Ardent Performance Computing
Are you in the Pacific Northwest? This Thursday Sep 4 at 6pm we have special guest Nikolay Samokhvalov visiting Seattle and speaking at the Seattle Postgres User Group! Nik is the founder of Postgr…| Ardent Performance Computing
Just a short post, because I thought this was pretty remarkable. Below, I have screenshots showing the CPU utilization of two AWS instances in us-west-2 which are running an identical workload. The…| Ardent Performance Computing
Collation torture test results are finally finished and uploaded for Debian. 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 …| Ardent Performance Computing
On February 25, 2025 Christoph Berg committed the patch: This closed Debian bug 927182 which had been opened in April 2019 by Laurence Parry. That bug had raised concerns over the significant size increase of adding LLVM as a requirement to support Postgres JIT functionality. Postgres supports packaging LLVM as a separate optional package without … Continue reading →| Ardent Performance Computing
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 …| Ardent Performance Computing
This month’s PGSQL Phriday #015 topic is about UUIDs, hosted by Lætitia Avrot. Lætitia has called for a debate. No, no, no. I say let’s have an all-out war. A benchmark war. I have deci…| Ardent Performance Computing
You can cut-and-paste the following commands to quickly get a new & clean dev environment for working with PostgreSQL source code. This includes Michael Paquier’s powerful script kit for …| Ardent Performance Computing
This month’s PGSQL Phriday #014 is about PostgreSQL Events, and it’s a great time to give an update about the Seattle Postgres User Group where I’ve been working together with lon…| Ardent Performance Computing
Hello, let me introduce myself. Today, we’ll pretend that I’m a linguistics researcher. I don’t know much about databases, but I do know a lot about the Balti language of northern…| Ardent Performance Computing
Update 7/18: y’all guessed the answer to my puzzle very fast! At the bottom of this blog post, I’ve added the expressions that I used (with credit to those who guessed it), and also oth…| Ardent Performance Computing
Update 2024-Jan-24: this post has been linked from a few places after I wrote it in 2021. Just wanted to mention that there’s been ongoing discussion about logical replication and PostgreSQL.…| Ardent Performance Computing
At the Seattle PostgreSQL User Group meetup this past Tuesday, we got onto the topic of invalid pages in PostgreSQL. It was a fun discussion and it made me realize that it’d be worth writing …| Ardent Performance Computing
