Re: Partition table Creation and Testing using Inherited method

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: dbatoCloud Solution <dbatocloud17(at)gmail(dot)com>
Cc: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: Partition table Creation and Testing using Inherited method
Date: 2021-03-03 11:04:54
Message-ID: 60c0034b99baa51101ed9c2f94ed1e54029c6e2c.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message dbatoCloud Solution 2021-03-03 11:36:52 Re: Partition table Creation and Testing using Inherited method
Previous Message Victor Sudakov 2021-03-03 10:34:27 Re: load balancer and connection pooling combined