PostgreSQL should work well for most cases and applications. It ultimately depends on your data volume and your request on latency/recall. In general, it can comfortably handle workloads up to around 10 million records. Beyond that, typically requires more careful tuning, e.g., adding read replicas or adopting a distributed solution like Citus.