· 1 min · Python, Tools

datadog-uwsgi-stats

A lightweight Datadog plugin for uWSGI monitoring, because sometimes the old guard needs observability too.

0 comments

· 3 min · PostgreSQL

All Your GUCs in a Row: enable_sort

Disable `enable_sort` to fix a slow sort? Wrong target. Slow sorts need more `work_mem` or better indexes—not this GUC.

0 comments

· 1 min · Python, Rust

Chisel: A transactional, crash-safe embedded storage engine

PGX introduces Chisel, a Rust-based key-value engine that guarantees crash safety through shadow paging, no write-ahead log or recovery needed.

0 comments

· 3 min · PostgreSQL

All Your GUCs in a Row: enable_seqscan

`enable_seqscan = off` doesn't disable sequential scans—it penalizes them. The planner still uses them when it has no other option, and that's by design.

0 comments

· 3 min · PostgreSQL

All Your GUCs in a Row: enable_self_join_elimination

You are rarely the only thing writing your SQL. Your ORM writes some of it, your nested views write more, and sooner or later one of them joins a table to itsel

0 comments

· 4 min · PostgreSQL

The Version Number Is Not the Territory

A PostgreSQL 14 database threw an error that PostgreSQL 14 cannot produce.

0 comments

· 3 min · PostgreSQL

All Your GUCs in a Row: enable_presorted_aggregate

PostgreSQL 16's `enable_presorted_aggregate` defaults to on, and the only reason to turn it off is for that one query where the planner's cost model guesses…

0 comments

· 4 min · PostgreSQL

All Your GUCs in a Row: enable_partitionwise_join

Partitionwise join decomposes big joins into smaller per-partition pairs when both tables partition on the join key—but only if you enable it and meet strict…

0 comments

· 4 min · PostgreSQL

All Your GUCs in a Row: enable_partitionwise_aggregate

PostgreSQL's unusual enable_* parameter that defaults off: partitionwise aggregation trades memory for speed, and only you know if that deal is worth it for…

0 comments

· 4 min · PostgreSQL

All Your GUCs in a Row: enable_partition_pruning

PostgreSQL's partition pruning eliminates unnecessary partition scans in two distinct phases — at plan time and execution time — and you need to check…

0 comments