ysg>
From: Laurenz Albe
Sent: Thursday, February 29, 2024 9:32:48 AM
To: David Kelly ;
pgsql-performance@lists.postgresql.org
Subject: Re: Table Partitioning and Indexes Performance Questions
On Thu, 2024-02-29 at 11:42 -0500, David Kelly wrote:
> I was
On Thu, 2024-02-29 at 11:42 -0500, David Kelly wrote:
> I was told that partitioned table indexed must always start with the
> partition key columns.
That's not true.
Only unique indexes (as used by primary key and unique constraints) must
contain the partitioning key (but they don't have to sta
