Chris van Eijk: json vs jsonb in PostgreSQL: size and speed, measured
json vs jsonb in PostgreSQL 17 and 18, measured on six document shapes: when jsonb is 23% smaller or 41% larger, read speed, GIN, and what it changes.
Topic - Edition
Databases
Vadim Yatsenko: The Server-First Reader Pool: Exact Connection Reuse and Hot-Path Performance
Once a proxy decides which replica should serve a read, it still has to find or create a connection to that replica. This article is about how Polar Proxy organizes its reader connection pool and trims the hot path so…
Fix Supabase "Invalid Refresh Token" and "Auth session missing!"
You were signed in a minute ago. You refreshed the page, opened a second tab, or clicked around as usual — and now you are on the login screen. The console says Invalid Refresh Token, Refresh Token Not Found, or the…
Hollis Varden: Thirteen small measurements on PostgreSQL 18
These are thirteen things I measured in one sitting. Each one is small. A few of them surprised me anyway. Setup PostgreSQL 18.6, built from source, default settings (work_mem 4MB, shared_buffers 128MB, 2 parallel…