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
Wrapped up in intensive PostgreSQL query optimization effort. Tactics: PK/FK data type change, de-normalization, CTE restructure. Results: 77% faster target COUNT(*) query: 75ms vs. 330ms. 96% less IO (fewer buffers). Now the (2nd) hard part: getting these changes into the prod DB and app code. 😅
2025-02-10T17:02:20.555Z