Comment Comment by xsc It seems a solid first step would be to use EXPLAIN to understand query planning/scanning issues.Assuming 6.5M rows/day*1.5yr=~3.5B rows, how large is the dataset in both SQLite and pg? With indexes, is it fitting in RAM?Linode 2GB plan is shared vcpu, so results will vary depending on who is sharing it with your service. parent xsc 4 years ago
Assuming 6.5M rows/day*1.5yr=~3.5B rows, how large is the dataset in both SQLite and pg? With indexes, is it fitting in RAM?
Linode 2GB plan is shared vcpu, so results will vary depending on who is sharing it with your service.