[openstreetmap/openstreetmap-website] performance reduced when updating/migrating (#2980)

[caleb87]

I tried to migrate and update to a different server, but the read/write performance has went drastically down even though it should have went up.

**Old Setup**: Ubuntu 16, AWS with 32gb ram, 4 threads, 2.5ghz, EBS SSD, postgresql 9.5
Loads the bbox in 18 seconds: /api/0.6/map?bbox=-97.58167,35.385,-97.51833,35.44833

**New Setup:** Ubuntu 20, 128gb ram, 128 threads, 3.8ghz, m.2 500k IOPS read/write, postgresql 12
Loads the bbox in 144 seconds


Postgresql config is the same, but shared_buffers was changed from 10GB to 90GB.

The production server fetches the bbox in 2.5 seconds. 

 Any idea what could be causing the performance issue?

-- 
You are receiving this because you are subscribed to this thread.
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/openstreetmap-website/issues/2980
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/rails-dev/attachments/20201124/b45fa879/attachment.htm>