Hacker News Reader

Even reading from disk ought to be way faster than the typical Postgres use case of going over the network, shouldn't it?

View on HN

I would expect Postgres to be faster for complex operations over large datasets (of course with a helping of "It depends!"), but very interested in knowing if this is generally untrue.

This is generally untrue, depending on what you mean by "faster".

The way most web apps use DBs, sqlite is incredibly fast. Because most web apps make multiple queries, often sequentially, and they're very sensitive to DB latency. The network overhead adds up: https://twitter.com/benbjohnson/status/1514969870529560580

It's faster even if the PostgreSQL instance is on the same box. If PostgreSQL is on a different box, then it's a lot faster.

Reply on news.ycombinator.com