Postgres Pro
Downloads
Home   >   mailing lists

Re: Partition By Range Without PrimaryKey : Postgresql Version 12.8 on AWS RDS - Mailing list pgsql-admin

From Scott Ribe
Subject Re: Partition By Range Without PrimaryKey : Postgresql Version 12.8 on AWS RDS
Date
Msg-id 2BE78422-2D94-424F-ACA7-1FBAA62D7F5E@elevated-dev.com
Whole thread Raw
In response to Re: Partition By Range Without PrimaryKey : Postgresql Version 12.8 on AWS RDS  (Scott Ribe <scott_ribe@elevated-dev.com>)
Responses RE: Partition By Range Without PrimaryKey : Postgresql Version 12.8 on AWS RDS
List pgsql-admin
Tree view 
> On May 22, 2023, at 7:17 AM, Scott Ribe <scott_ribe@elevated-dev.com> wrote:
>
> 3) don't partition on it, index (brandid, playerid, placedon)

Oops, given that you're looking for latest placedon, not a specific one, make that (placedon, playerid, brandid)

pgsql-admin by date:

Previous
From: Scott Ribe
Date:
Subject: Re: Partition By Range Without PrimaryKey : Postgresql Version 12.8 on AWS RDS
Next
From: kaido vaikla
Date:
Subject: Re: pg_stat_activity query_id