Contributors mailing list archives
Re: Postgresql Table partitioning in Odooby
Open Source Integrators, Daniel Reis
In some cases Partial Indexes can do the trick.
For example, you could have a partial index only for active records. Since most of the time there is filter condition on the active field, the smaller partial index can be used instead of a full index.
This can give you the same benefits as a partitioned table, with a simpler solution (no need to push data around).
No dia 26/02/2021, às 19:17, Jordi Ballester Alomar <firstname.lastname@example.org> escreveu:
Dear contributors,We have a case of a database where some tables, like account.move.line are growing to absurd numbers of records. At this point we are considering using Postgresql Table partitioning to speed up performance. Has anyone of you had experience with table partitioning?Looking forward to hearing your thoughts.