August | 2025 | Ardent Performance Computing
1 post published by Jeremy during August 2025| Ardent Performance Computing
1 post published by Jeremy during August 2025| 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
1 post published by Jeremy during January 2024| 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
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 →| Ardent Performance Computing
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 →| Ardent Performance Computing
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 →| 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 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 →| Ardent Performance Computing
This option didn’t seem super widely documented from my initial searches online; it should be able to basically enforce layer 4 ingress/firewall rules at the individual service level. This is…| Ardent Performance Computing
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: Wait event counters an…| Ardent Performance Computing
As Joe Drumgoole said a few days ago: so many Postgres providers. Aiven, AWS, Azure, Crunchy, DigitalOcean, EDB, GCP, Heroku, Neon, Nile, Oracle, Supabase, Tembo, Timescale, Xata, Yugabyte… 🤯…| 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
