News for hackers. Stuff that matters.
Re:Our Journey to PostgreSQL 12 by sk5t on Tuesday January 26, 2021 @02:04AM (#25913309)
Did you consider lowering those IOPS with application-level and/or distributed in-memory cache and/or pub-sub notifications to let your app nodes not pester the database so much? Reasonably performant hand-written SQL (no ORM!), review of query plans, maybe shift the hot path into functions/procs?
Re:Our Journey to PostgreSQL 12 by tommyzli on Tuesday January 26, 2021 @02:36AM (#25913448)
Believe it or not these numbers are actually from _after_ me and some others spent a few weeks cleaning up our heavier queries