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

Paul Norman notifications at github.com
Fri Nov 30 16:32:06 UTC 2018


> Well I imagine they are mostly, if not all, on the id column but I don't see anything which allows that in that text?

If you partition on id and have a primary key on id, any two duplicate ids will have to go to the same leaf, where they would violate the unique constraint on the leaf.

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


More information about the rails-dev mailing list