TE
TechEcho
Home24h TopNewestBestAskShowJobs
GitHubTwitter
Home

TechEcho

A tech news platform built with Next.js, providing global tech news and discussions.

GitHubTwitter

Home

HomeNewestBestAskShowJobs

Resources

HackerNews APIOriginal HackerNewsNext.js

© 2025 TechEcho. All rights reserved.

PostgreSQL 10: Partitions of partitions

140 pointsby joaodlfover 7 years ago

4 comments

da_chickenover 7 years ago
No primary/unique keys on the partition table and only on the partitions still seems like a common dealbreaker.
评论 #16195244 未加载
评论 #16196035 未加载
评论 #16195071 未加载
评论 #16195162 未加载
kdvover 7 years ago
Is anyone that was using pg_partman before migrated to native partitioning yet? No support for ON CONFLICT and PKs are serious limitations that are available with pg_partman.
评论 #16195440 未加载
simonwover 7 years ago
Can anyone offer a really basic summary of what problems can be solved with PostgreSQL partitions?
评论 #16195491 未加载
评论 #16195289 未加载
评论 #16195336 未加载
评论 #16195212 未加载
评论 #16195423 未加载
评论 #16195203 未加载
gregn610over 7 years ago
How is this better than inherited tables with indexes and constraints ala <a href="https:&#x2F;&#x2F;stackoverflow.com&#x2F;a&#x2F;3075248" rel="nofollow">https:&#x2F;&#x2F;stackoverflow.com&#x2F;a&#x2F;3075248</a>