3 ms·
I think we can assume on his Macbook it was SQLite running on NVMe, and even so SQLite was out monstered by PostgreSQL by a large margin according to his figure
by rstuart4133 3y ago
I think we can assume on his Macbook it was SQLite running on NVMe, and even so SQLite was out monstered by PostgreSQL by a large margin according to his figures.
It would be interesting to know why. I would have thought for single queries the IPC overhead would put PostgreSQL at a disadvantage. Apparently not.
In fact a lot of things are puzzling. I would have expected PostgreSQL to win when there are lots of independent queries because it can aggressive caching, whereas SQLite has to assume lots of independent process are having their way the the database. Again that didn't happen - the rate speed dropped as the query rate increased was similar for both.