.tips
page 7 of 10, 228 small things in all. back to the first.
.march
2026, 19 tips.
Turn on pg_stat_statements before you need it
postgresqlobservability
PIPESTATUS tells you which command in a pipe failed
shell
printf, not echo, in scripts
shell
synchronous_commit = off is fine for at-least-once work
postgresqlperformance
pv shows progress on anything you pipe
shell
Enforce idempotency with a partial unique index
postgresqldistributed-systems
ssh -L reaches a database that is only on the private network
shelloperations
lsof -i :3000 names the process holding the port
shelldebugging
RETURNING can give you the old row too
postgresql
curl -w prints where the time went
shellhttp
comm compares two sorted lists in one pass
shell
Index the rows you query, with a WHERE on the index
postgresqlperformance
awk '!seen[$0]++' dedupes without sorting
shell
Always run EXPLAIN with ANALYZE and BUFFERS
postgresqlperformance
rg and fd, and let the .gitignore do the filtering
shelltooling
--first-parent reads a merge-heavy history as a timeline
git
An UNLOGGED table is a cache that speaks SQL
postgresqlcaching
rebase.autostash saves the stash dance
git
New tables get uuidv7() as the default
postgresqlschema-design
.february
2026, 6 tips.
range-diff shows what a rebase actually changed
gitcode-review
blame with -w -C to see through reformatting
git
FOR UPDATE SKIP LOCKED is the whole queue
postgresqlqueues
--word-diff for prose and long lines
git
git stash leaves new files behind unless you say -u
git
reflog is the undo button for the rebase you regret
git