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 C995B307-FB34-46AD-99FA-392FAD216D4B@elevated-dev.com
Whole thread Raw
In response to RE: Partition By Range Without PrimaryKey : Postgresql Version 12.8 on AWS RDS  (Phani Prathyush Somayajula <phani.somayajula@pragmaticplay.com>)
List pgsql-admin
> On May 23, 2023, at 2:46 AM, Phani Prathyush Somayajula <phani.somayajula@pragmaticplay.com> wrote:
>
> What's wrong with partitioning by placedon, with a primary key of (betid, placedon)? - this is because the business
needto run group by queries based on these brands. For now, there are 4 brands and in future it could go up to 7. 

How does a primary key of (betid, placedon) instead of betid interfere with that?


pgsql-admin by date:

Previous
From: Phani Prathyush Somayajula
Date:
Subject: RE: Partition By Range Without PrimaryKey : Postgresql Version 12.8 on AWS RDS
Next
From: Scott Ribe
Date:
Subject: Re: Partition By Range Without PrimaryKey : Postgresql Version 12.8 on AWS RDS