News for hackers. Stuff that matters.
Re:PostgreSQL Count(*) Performance Improvements by ht85 on Thursday April 11, 2019 @01:10AM (#19631318)
Even though only 1 / 10 counters would be locked, you'd still have to read all 10 to get the count, which would be blocked until the concurrent transaction ended.
Re:PostgreSQL Count(*) Performance Improvements by ants_a on Thursday April 11, 2019 @02:24AM (#19631655)
With MVCC writers don't block readers.