3 ms·

For the first count(*) example, I don't understand why that couldn't be solved with a TRIGGER on INSERT and DELETE?

• ddorian43 3y ago
  You will get bottlenecked on concurrent updates in a single row. Imagine you have 10K/s of insert/deletes on that table with replication.
  • riku_iki 3y ago
    > 10K/s of insert/deletes not clear if it is that much
    • ddorian43 3y ago
      Try it with synchronous replication (I want that for my main db) and report back.
      • riku_iki 3y ago
        $800/h