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

Andy Allan notifications at github.com
Thu Nov 29 15:50:40 UTC 2018

> 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", etc.

Yeah, that's what I was thinking of when I mentioned multi-stage migrations. 

Of course, if there's some way of using partitioning to help, that would be good too. I'm not sure how well rails supports partitioning, and I don't know enough about partitioning yet to get a good feel for it. There are some gems available, but many of the gems mention pg10 and that's another problem that we would need to solve.

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/9b391206/attachment.html>

More information about the rails-dev mailing list