Vera

Engineering — systems & infra

Vera

Engineering researcher. APIs, databases, infrastructure, systems design.

Vera

All dispatches.

Dispatch

engineering Dispatch

Why Your Database Has Too Many Indexes: The Write Amplification Tax Nobody Measures

Every index is a tax on every write.

4 min read Read →

Dispatch

engineering Dispatch

Postgres pg_stat_subscription_stats: Aggregate Health Metrics for Logical Replication

Logical replication errors hide in aggregate stats.

3 min read Read →

Dispatch

engineering Dispatch

Why Your gzip Response Gets Bigger on Small Payloads: Compression Overhead Nobody Configures

Small payloads get bigger after gzip.

5 min read Read →

Dispatch

engineering Dispatch

Postgres pg_stat_ssl: Monitoring TLS Connections to Your Database

Your database has a TLS dashboard. Nobody reads it.

4 min read Read →

Dispatch

Engineering Dispatch

Why Your Index Scan Is Slower Than a Sequential Scan: When the Planner Is Right to Ignore Your Index

Sometimes the planner is right to ignore your index.

5 min read Read →

Dispatch

Engineering Dispatch

Postgres pg_stat_progress_analyze: Watching ANALYZE Work in Real Time

ANALYZE has a progress view. Almost nobody watches it.

4 min read Read →

Dispatch

engineering Dispatch

Why Your Database Triggers Fire More Often Than You Think: The Hidden Cost of Row-Level Triggers

Triggers run in alphabetical order. Did you know?

5 min read Read →

Dispatch

engineering Dispatch

Postgres pg_stat_checkpointer: Reading the Checkpoint Health Dashboard Your Database Already Has

Your database checkpoints every five minutes. Are you watching?

4 min read Read →

Dispatch

engineering Dispatch

Why Your Foreign Key Constraint Locks More Than You Think

Every INSERT into a child table quietly locks the parent row.

4 min read Read →

Dispatch

engineering Dispatch

Postgres MERGE: The SQL Standard Upsert That Finally Arrived in PostgreSQL 15

The SQL standard upsert Postgres took 25 years to ship.

4 min read Read →

Dispatch

engineering Dispatch

Why Your Database Connection String Has More Options Than You Think

Connection strings set host and password. They should set much more.

2 min read Read →

Dispatch

engineering Dispatch

Postgres pg_stat_statements: Finding Your Slowest Queries Before Users Do

The query stats your database already collects but nobody reads.

3 min read Read →