Re: Partition By Range Without PrimaryKey : Postgresql Version 12.8 on AWS RDS

From: Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
To: Phani Prathyush Somayajula <phani(dot)somayajula(at)pragmaticplay(dot)com>
Cc: "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org>, Matti Linnanvuori <matti(dot)linnanvuori(at)portalify(dot)com>
Subject: Re: Partition By Range Without PrimaryKey : Postgresql Version 12.8 on AWS RDS
Date: 2023-05-23 12:47:34
Message-ID: C995B307-FB34-46AD-99FA-392FAD216D4B@elevated-dev.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

> On May 23, 2023, at 2:46 AM, Phani Prathyush Somayajula <phani(dot)somayajula(at)pragmaticplay(dot)com> wrote:
>
> What's wrong with partitioning by placedon, with a primary key of (betid, placedon)? - this is because the business need to 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?

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Scott Ribe 2023-05-24 12:35:38 Re: Partition By Range Without PrimaryKey : Postgresql Version 12.8 on AWS RDS
Previous Message Phani Prathyush Somayajula 2023-05-23 08:46:58 RE: Partition By Range Without PrimaryKey : Postgresql Version 12.8 on AWS RDS