test

This tag is associated with 3 posts

Zero autovacuum_vacuum_cost_delay, Write Storms, and You

Posted by Jeremy ⋅ April 12, 2026 ⋅ 5 Comments

A few days ago, Shaun Thomas published an article over on the pgEdge blog called [Checkpoints, Write Storms, and You]. Sadly a lot of corporate blogs don’t have comment functionality anymore. I left a few comments [on LinkedIn], but overall let me say this article is a great read, and I’m always happy to see … Continue reading →

Testing loadBalancerSourceRanges with CloudNativePG on Azure Kubernetes

Posted by Jeremy ⋅ March 14, 2025 ⋅ Leave a comment

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 a quick test to check if it works. Steps were generated with ChatGPT, and mostly worked. It missed Azure provider registration, but I figure that … Continue reading →

UUID Benchmark War

Posted by Jeremy ⋅ February 3, 2024 ⋅ 5 Comments

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 decided to orchestrate a benchmark war between four different methods of storing a primary key: The challenge is simple: insert one … Continue reading →