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

mmd notifications at github.com
Thu Nov 29 14:28:45 UTC 2018

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

More information about the rails-dev mailing list