Re: Partitioned Table Index Column Order

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: Rumpi Gravenstein <rgravens(at)gmail(dot)com>
Cc: PostgreSQL <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Partitioned Table Index Column Order
Date: 2021-06-23 22:55:40
Message-ID: 202106232255.3gmtpm5lzc2p@alvherre.pgsql
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tomas Vondra 2021-06-23 22:56:04 Re: How to hash a large amount of data within Postgres?
Previous Message Rumpi Gravenstein 2021-06-23 22:31:40 Partitioned Table Index Column Order