Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

You could do that, but you'd run into exactly the same bottleneck the author describes with a remote Postgres instance. The workload exposes high contention on hot rows. If transactions are kept open for several milliseconds due to this being a remote network call between client and DB server, throughput will be equally limited also when using SQLite.


Yeah this is a very good point. Any sort of network drive will have similar issues with SQLite. You're very much wanting attached NVME.




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: