[kccqzy]

But OP never said it's a CRUD app. Maybe OP did some experimentation with OLAP use cases.

[vagab0nd]

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]

Regardless of your use case, EXPLAIN ANALYZE can show you whether there's any room for improvement.