aws

This tag is associated with 2 posts

Graviton2 versus Graviton4

Posted by Jeremy ⋅ August 3, 2025 ⋅ 2 Comments

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. They are running the CloudNativePG playground, which is a production-like learning and testing environment (all running virtually inside the single ec2 instance, which can … Continue reading →

Postgres Indexes, Partitioning and LWLock:LockManager Scalability

Posted by Jeremy ⋅ March 3, 2024 ⋅ 4 Comments

I have decided that – in Postgres circles – I shall henceforth refer to 2023 as THE YEAR OF THE LOCK MANAGER’S REVENGE. Let me explain. Lets start with Bruce Momjian. He has an in-depth presentation about locking in general with PostgreSQL called “Unlocking the Postgres Lock Manager“. I see online that he’s been giving … Continue reading →