This is a heavily interactive web application, and JavaScript is required. Simple HTML interfaces are possible, but that is not what this is.
Post
Andrew Atkinson
andyatkinson.com
did:plc:iveg5v7kpg6zzbrok7gmp4ia
Query joins 3 tables with record counts of 2, 4000, and 4 million. All using UUID v4 PKs. Big table is a sequential scan, no buffer cache hits.
Experimenting by replacing all PKs and FKs with bigint. What was the result?
Big table now accessed as index only scan from buffer cache. 300ms vs. 800ms.
2025-01-17T01:33:02.557Z