4 ms·

"sub-100ms queries" is not a high bar to clear. Milliseconds isn't even the right measurement.

• kijin 8mo ago
  In a typical CRUD web app, any query that takes milliseconds instead of microseconds should be viewed with suspicion. In a more charitable interpretation, maybe the parent is talking about sub-100ms total round trip time for an API call over the public internet.
  • kccqzy 8mo ago
    But OP never said it's a CRUD app. Maybe OP did some experimentation with OLAP use cases.
    • vagab0nd 8mo ago
      OP here. Roughly 50GB in db size. Fairly standard queries (full-text search + filters). Most queries are on the order of 10-100ms. Some more complex ones involving business logic exceeds 100ms. This is well within my budget, but it sounds like there might be room for improvements?
      • kijin 8mo ago
        Regardless of your use case, EXPLAIN ANALYZE can show you whether there's any room for improvement.
      • tovlier 8mo ago
        [dead]