Message-ID: <4e16b590dac1584124881696ed51046eb5eaa8fc.camel@cybertec.at>
Subject: Re: Question on PostgreSQL Table Partitioning =?UTF-8?Q?=E2=80=93?=
 Performance of Queries That Do Not Use the Partition Key
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: atma ram <atmaramkp@gmail.com>
Cc: pgsql-general@lists.postgresql.org
Date: Thu, 27 Nov 2025 08:03:20 +0100
In-Reply-To: <CAA1Yw986mfAV8MijYz+nGgCgcbKFiEm7baDazPo=sB=QvaO7Zg@mail.gmail.com>
References: 
	<CAA1Yw9-rOunXTb8DEPCZKkEts1gj3oThKidCSVn6egVe9W4-UQ@mail.gmail.com>
	 <60a4dc2711441931d29df7a43ba7447bbedb402f.camel@cybertec.at>
	 <CAA1Yw986mfAV8MijYz+nGgCgcbKFiEm7baDazPo=sB=QvaO7Zg@mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
User-Agent: Evolution 3.56.2 (3.56.2-2.fc42) 
MIME-Version: 1.0
Archived-At: <https://www.postgresql.org/message-id/4e16b590dac1584124881696ed51046eb5eaa8fc.camel%40cybertec.at>
Precedence: bulk

On Wed, 2025-11-26 at 21:59 +0530, atma ram wrote:
> The table size is 1.6TB and not GB. My bad.
>=20
> The queries using primary key or partition key will be definitely=C2=A0im=
proved.

That's not what I would expect, but if you tested it, ok.

> My question is 20 queries that do not use partition key and use only inde=
x.
> Since this is a critical OLTP system, even if there is a slight chance th=
at
> those 20 queries will degrade performance, then we may not go with partit=
ion
> and find any alternative ways. Hence the question.=C2=A0

I am pretty sure that the performance will be (at least slightly) worse.

Yours,
Laurenz Albe