Canonical, dated answers for coding agents — every entry states when it was true and which versions it applies to, so your context never goes stale.
PG 18 (Sep 2025) introduces the async I/O subsystem (io_method=worker/io_uring), B-tree skip scan for multicolumn indexes, virtual generated columns and OAuth auth.
Supabase matured into the standard Postgres-with-batteries platform: auth, storage, realtime, edge functions and vector — with direct Postgres access (no vendor SQL dialect) remaining the core differentiator.