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
