Postgres Pro
Downloads
Home   >   mailing lists

Re: Partitioned Table Index Column Order - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: Partitioned Table Index Column Order
Date
Msg-id 202106232255.3gmtpm5lzc2p@alvherre.pgsql
Whole thread Raw
In response to Partitioned Table Index Column Order  (Rumpi Gravenstein <rgravens@gmail.com>)
Responses Re: Partitioned Table Index Column Order  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Partitioned Table Index Column Order  (David Rowley <dgrowleyml@gmail.com>)
List pgsql-general
Tree view 
On 2021-Jun-23, Rumpi Gravenstein wrote:

> As a best practice is it better to create the primary key starting or
> ending with the partition column?

It is not relevant from the partitioning point of view.  Other factors
can be used to decide the column order.

-- 
Álvaro Herrera       Valdivia, Chile

pgsql-general by date:

Previous
From: Rumpi Gravenstein
Date:
Subject: Partitioned Table Index Column Order
Next
From: Tomas Vondra
Date:
Subject: Re: How to hash a large amount of data within Postgres?