On Wed, 2021-03-03 at 14:31 +0530, dbatoCloud Solution wrote:
> Thanks! I understood the problem, But, at this moment it is not possible to
> upgrade the DB version (10.13) to 11 or 12 due to a sprint issue.
PostgreSQL v10 already has (limited) partitioning support, but I'd
rather use that than inheritance partitioning.
> Is there any other way to improve the performance?
Partitioning typically doesn't improve query performance...
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com