[openstreetmap/openstreetmap-website] Partition large tables (#2076)

[mmd]

One strategy to deal with data type changes is outlined in the following blog posts:

Instead of "Change the type of a column", " Add a new column, change the code to write to both columns, and backfill the new column".

* https://jilt.com/blog/migrations-zero-downtime-rails/
* https://www.braintreepayments.com/blog/safe-operations-for-high-volume-postgresql/

For sure that's more effort, it all depends a bit on how long a read only or offline periods may take at most.


-- 
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/2076#issuecomment-442853014
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/rails-dev/attachments/20181129/71da7165/attachment.html>