bouvyd’s avatarbouvyd’s Twitter Archive—№ 1,061

  1. …in reply to @bealdav
    @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.
    On twitter.com Twitter logo bouvyd’s avatar ♻️ 1 Retweets ❤️ 1 Favorite Mood +3 🙂
    1. …in reply to @bouvyd
      @bealdav A lot of partners don't even bother configuring their Postgres server properly, adding partitioning on top is not a good idea imho.
      Permalink On twitter.com Twitter logo bouvyd’s avatar Mood +3 🙂
    2. …in reply to @bouvyd
      @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?
      Permalink On twitter.com Twitter logo bouvyd’s avatar Mood 0