3 ms·

I was more interested in knowing performance characteristics. For the same service how did RAM+CPU load change pre and post migration?

• dannyibunny 5y ago
  Postgres is much heavier than SQLite in terms of binary size/CPU/RAM, but I think scalability is the win.
  • masklinn 5y ago
    OTOH if you don't tune it the default postgres configuration remains extremely low-resource (which also hampers its performances): 128MB shared buffers, 8MB temp buffers, 4MB work_mem, 64MB maintenance_work_mem, 100 connections, 1000 files open.
    • mayli 5y ago
      Compared to less than 1MB for sqlite in this use case.