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 3ACB6DC6-E93B-45ED-B571-993A7190DEC1@elevated-dev.com
Whole thread Raw
In response to 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 10:30 PM, Phani Prathyush Somayajula <phani.somayajula@pragmaticplay.com> wrote:
>
> Didn't quite get the question, Scott

I asked, what's wrong with partitioning by placedon, with a primary key of (betid, placedon). You responded that the
clienthas some queries which group by brandid. How does adding placedon to the primary key interfere with that? 

At no point have you explained how adding placedon to the primary key is a problem. I expect it is not actually a
problem.It seems that you should just do what the error suggested, add placedon to the primary key. 


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: Ravi GH
Date:
Subject: PG Database Encryption