pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Scott Ribe <scott_ribe@elevated-dev.com>
To: Phani Prathyush Somayajula <phani.somayajula@pragmaticplay.com>
Cc: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Cc: Matti Linnanvuori <matti.linnanvuori@portalify.com>
Subject: Re: Partition By Range Without PrimaryKey : Postgresql Version 12.8 on AWS RDS
Date: Tue, 23 May 2023 06:47:34 -0600
Message-ID: <C995B307-FB34-46AD-99FA-392FAD216D4B@elevated-dev.com> (raw)
In-Reply-To: <VI1PR10MB76711ADD5EDBD1D981BA30F18D409@VI1PR10MB7671.EURPRD10.PROD.OUTLOOK.COM>
References: <VI1PR10MB76711B1B17D38E3CFF4E73008D439@VI1PR10MB7671.EURPRD10.PROD.OUTLOOK.COM>
	<VI1PR10MB7671180739AB51DF1455A1A48D439@VI1PR10MB7671.EURPRD10.PROD.OUTLOOK.COM>
	<404AADDB-83F9-4A4A-B6D7-E736C278EFDA@portalify.com>
	<VI1PR10MB7671D817E765A2ADFA174CAD8D439@VI1PR10MB7671.EURPRD10.PROD.OUTLOOK.COM>
	<9558F0D3-4B5B-4CE2-A27F-156149E75916@elevated-dev.com>
	<2BE78422-2D94-424F-ACA7-1FBAA62D7F5E@elevated-dev.com>
	<VI1PR10MB7671781EA8ADC72B088F1D318D439@VI1PR10MB7671.EURPRD10.PROD.OUTLOOK.COM>
	<5F09A2FE-117F-47D4-B78B-25023A02AFB7@elevated-dev.com>
	<VI1PR10MB76711ADD5EDBD1D981BA30F18D409@VI1PR10MB7671.EURPRD10.PROD.OUTLOOK.COM>

> 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 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?




view thread (18+ messages)  latest in thread

Message-ID: <C995B307-FB34-46AD-99FA-392FAD216D4B@elevated-dev.com>
Permalink:  ../C995B307-FB34-46AD-99FA-392FAD216D4B@elevated-dev.com/
Also on:    postgresql.org/message-id/C995B307-FB34-46AD-99FA-392FAD216D4B@elevated-dev.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: scott_ribe@elevated-dev.com, phani.somayajula@pragmaticplay.com, pgsql-admin@lists.postgresql.org, matti.linnanvuori@portalify.com
  Subject: Re: Partition By Range Without PrimaryKey : Postgresql Version 12.8 on AWS RDS
  In-Reply-To: <C995B307-FB34-46AD-99FA-392FAD216D4B@elevated-dev.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox