3 ms·
Even reading from disk ought to be way faster than the typical Postgres use case of going over the network, shouldn't it?
by nickcox 4y ago
Even reading from disk ought to be way faster than the typical Postgres use case of going over the network, shouldn't it?
- chillfox 4y agoIt'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.
- pcthrowaway 4y agoI 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.
- mrkurt 4y agoThis 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 https://twitter.com/benbjohnson/status/1514969870529560580