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.
Daily edition · PostgreSQL
The daily ledger
TILens turns technical updates into a focused daily brief: official releases, trusted reporting, and practitioner analysis, deduplicated and organized by topic.
4 articles · 2 sources ·
Top topics: PostgreSQL · JavaScript
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…