-
@bealdav We have tables (on odoo.com and for some customers) with tens of millions of rows that work fine without partitioning, you just need to administer your db *correctly* (config, indices...). 6M is not that big a deal.Permalink On twitter.com
♻️ 1 Retweets
❤️ 1 Favorite
Mood +3 🙂
-
@bealdav Global indices on partitioned tables are not possible. Also, something I didn't know that make this an even worse idea: fkeys from/to partitioned tables are not allowed. I honestly don't think such a trade-off is worth it. Won't somebody please think of the data consistency?On twitter.com
Mood 0