Postgres and Open Source Experts

Anytime. Anywhere. Since 1997.

Blog

Parquet and Iceberg: An Overview

A pile of containers is not a shipment. A shipment is containers plus a manifest.

Apache Iceberg is the manifest. It is not a file format, it is a table format: a metadata layer that records exactly which Parquet files make up a table at every point in time. That one idea buys you things we used to think required a warehouse. Transactions on object storage, so writers never corrupt …

Beyond the 25% Rule: shared_buffers Behavior in Large-Memory PostgreSQL

Beyond the 25% Rule: shared_buffers Behavior in Large-Memory PostgreSQL

Tuning shared_buffers isn't just about peak throughput — it's about how much CPU and disk I/O a system consumes per unit of work. The 25% default can require up to 5x more disk I/O than very low or very high allocation. Part 1 of 3.

The Architect

The Architect

Examine your own work honestly. Which job are you doing? If everything you contributed last quarter could be described as construction, start climbing. Learn the bearing loads. Learn the customer. Learn why the light should come from the east. Develop an opinion about what is beautiful and be ready to defend it. The tools are sitting right there and they have never been cheaper.

Romancing the Claude

He was very tall in a way that seemed apologetic, as if he had been issued the height by mistake and was still trying to give it back. He had a laugh he did not perform. When the moderator asked a genuinely stupid question, Dorian Vale did not smirk at the audience the way the other panelists did. He answered it seriously, and well, and the questioner sat down looking …

Your company is not AI ready

The engineers (myself included) stood on the rooftops and shouted, "People! My dear sheep of the earth, please let me save you from yourselves! Do not buy what the shiny man with the seductive words is selling!"

Direct AI effectiveness: plx example

AI as used by an experienced person with domain knowledge is like having another 5 experienced people doing exactly what you need them to do with minimal intervention.

When a 18TB backup just stopped

18TB backup just stopped. We fixed it through depth of knowledge.

Is Trust Gone? Supply Chain Attacks

Is Trust Gone?   Supply Chain Attacks

Is Trust Gone? Has the supply chain attacks eroded the trust we have in public repositories

What If Your Team’s Biggest Burnout Driver Lives in Your Database?

What If Your Team’s Biggest Burnout Driver Lives in Your Database?

Engineering leaders work hard to protect their teams from burnout — improving processes, hiring strong talent, and adjusting on-call rotations. But if your team still looks exhausted, the real issue may not be the rotation at all. It’s often the underlying database and infrastructure quietly triggering the same incidents over and over.

Why You Should Review Your Authentication Strategy

Why You Should Review Your Authentication Strategy

Released in July 2025, NIST SP 800-63 Revision 4 introduced new requirements for authentication strength, identity proofing, and federation security. Many organizations still haven't assessed their systems against these updated standards. Learn what changed, why it matters for compliance, and how to evaluate your current identity controls against the new framework.