2026-04-21
· 2 min
·
PostgreSQL
This obscure PostgreSQL setting exists only for the test suite to simulate replication on a single machine. You will never need it in production.
0 comments
2026-04-21
· 6 min
·
PostgreSQL
PostgreSQL 19 proposes `pg_plan_advice`: a pluggable plan-advice mechanism that lets you capture plan shapes via EXPLAIN and apply them without touching SQL.
0 comments
2026-04-20
· 2 min
·
PostgreSQL
PostgreSQL 17 added allow_alter_system to prevent accidental configuration drift when superusers reach for ALTER SYSTEM instead of your configuration…
0 comments
2026-04-20
· 5 min
·
PostgreSQL
PostgreSQL has officially rejected Oracle-style hints for two decades.
0 comments
2026-04-19
· 4 min
·
PostgreSQL
Query hints exist in every major database except PostgreSQL — until now.
0 comments
2026-04-18
· 1 min
After far too long, this blog’s conversion to PostgreSQL and Django is complete.
0 comments
2025-08-10
· 3 min
·
PostgreSQL
A viral Medium article claims PostgreSQL 18 is revolutionary with ten incredible new features.
3 comments
2025-04-02
· 1 min
·
PostgreSQL
Exposing PostgreSQL port 5432 to the public Internet invites brute-force attacks, DoS vulnerabilities, and potential data corruption.
0 comments
2025-01-28
· 2 min
·
PostgreSQL
PostgreSQL 12's INDEX_CLEANUP option can tank your query performance if misused. Learn when you absolutely need it, and why you almost certainly don't.
0 comments
2024-12-01
· 1 min
·
Python
Stale .pyc files from deleted Python modules can cause mysterious bugs in production. Always clean them out during deploys.
0 comments