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

[Paul Norman]

> I am much more concerned by the limitations listed at https://www.postgresql.org/docs/10/ddl-partitioning.html#DDL-PARTITIONING-DECLARATIVE-LIMITATIONS which suggest that many of our constraints would have to be dropped.

Do we have unique or exclusion constraints on the big tables aside from those which involve the partition key as the leading term? Looking at schema.sql I suspect the biggest table with a non-ID unique index is users, and that's not even at 10 million rows. All the primary keys have ID as the leading term, so if there are duplicates they would have to be in the same 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-443251852
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/rails-dev/attachments/20181130/cb04e9d8/attachment.html>