It all depends on so many factors, that “benchmark” is meaningless. What was the setup, what was the schema, what was the data, what was the cardinality, what access pattern, etc… 🐶🐾🫡
Discussion
Absolutely. This was just in my own experience with my own project. Only a few tables of json with high cardinality on a basic 1 vCPU and on 1gb ram NVMe vps. It's access patten was read-only as that was only what I wanted to test. I could run the same with less specs using sqlite than postgres. But again this was simply for my own project. I'm sure it might be different for another environment.
Oh yeah, your use case and HW specs are not PG candidate for sure. SQLite 💯🐶🐾🫡