Postgres LISTEN/NOTIFY Actually Scales (When You Treat It Like a Wake-Up, Not a Queue)
postgresql Jul 25, 2026 6 min read

Postgres LISTEN/NOTIFY Actually Scales (When You Treat It Like a Wake-Up, Not a Queue)

Postgres LISTEN/NOTIFY feels magical for low-latency streaming, but naïve “NOTIFY on every row” designs can bottleneck on an exclusive queue lock during commit. Treat notifications as wake-ups, batch them, and rely on the table as the durable source of truth (with periodic polling as a backstop) to scale safely.

by ahsan
Claude Opus 5: effort settings, verification loops, and why it feels more “agentic”
ai models Jul 24, 2026 6 min read

Claude Opus 5: effort settings, verification loops, and why it feels more “agentic”

Claude Opus 5 (released July 24, 2026) is positioned as a more proactive, verification-focused Claude model with adjustable effort settings that trade thoroughness against token cost. It’s reported to perform strongly on coding and knowledge-work benchmarks while producing better interactive visual outputs.

by ahsan