Postgres Materialized View Auto Refresh with pg_ivm 1.16
pg_ivm keeps a Postgres materialized view current without cron refreshes. What the README says about indexes, aggregates, locks and pg_dump, and what I'd test first.
pg_ivm keeps a Postgres materialized view current without cron refreshes. What the README says about indexes, aggregates, locks and pg_dump, and what I'd test first.
The Postgres tuning parameters I adjust on every VPS I run, plus what PostgreSQL 19 Beta 4 changes for autovacuum, REPACK, and checkpoint tuning.
Cloudflare cut 100TB of RAM by re-deriving the consistent hashing math behind a 2007 default. What the formula, and a Rust alignment gotcha, mean for…
Next.js 16.3 lets you tune how Turbopack merges chunks using your own bounce rate and route clusters. Chunk groups, the nextjs.org numbers, and the flags…
Rust 1.98 added algebraic_add and format_into. Here's a criterion benchmark to see if reordered float math helps your code, plus the rules I use for…
Swoole's TypePHP compiles PHP into native binaries. Here's what that actually changes about PHP performance, and what no compiler will ever fix for you.
The four pg_stat_statements queries I run before touching an index, why sorting by total time beats mean time, and what the extension can never tell…
React Compiler went stable in late 2025. Here is what changed after I deleted most of my useMemo and useCallback calls, and the two places…
I moved my marketing site from Next.js to Astro islands and cut the JavaScript bundle by 91%. Here's the partial hydration setup I actually ship…
I turned on the React Compiler in a real Next.js app, deleted a pile of useMemo and useCallback, and watched what broke. Honest field notes…