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

Paul Norman notifications at github.com
Wed Nov 28 17:30:24 UTC 2018


> And are you really saying that rewriting a column doesn't need to lock the whole set of chunks anyway? Can it really cope with half the chunks being in the old schema and half in the new schema?

Taking the nodes table with it's 8-12 billion rows as the worst, if we had 1 billion node partitions, we could do the column rewrite on all of them in parallel, and then rewrite the indexes on all of them at the same time. 

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


More information about the rails-dev mailing list