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 <pgsql-admin@lists.postgresql.org>
Subject: Re: Partition By Range Without PrimaryKey : Postgresql Version 12.8 on AWS RDS
Date: Wed, 24 May 2023 06:35:38 -0600
Message-ID: <3ACB6DC6-E93B-45ED-B571-993A7190DEC1@elevated-dev.com> (raw)
In-Reply-To: <VI1PR10MB7671DF7F20964960BEE76F7B8D419@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>
	<C995B307-FB34-46AD-99FA-392FAD216D4B@elevated-dev.com>
	<VI1PR10MB7671DF7F20964960BEE76F7B8D419@VI1PR10MB7671.EURPRD10.PROD.OUTLOOK.COM>

> 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 client has 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.




view thread (18+ messages)

Message-ID: <3ACB6DC6-E93B-45ED-B571-993A7190DEC1@elevated-dev.com>
Permalink:  ../3ACB6DC6-E93B-45ED-B571-993A7190DEC1@elevated-dev.com/
Also on:    postgresql.org/message-id/3ACB6DC6-E93B-45ED-B571-993A7190DEC1@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
  Subject: Re: Partition By Range Without PrimaryKey : Postgresql Version 12.8 on AWS RDS
  In-Reply-To: <3ACB6DC6-E93B-45ED-B571-993A7190DEC1@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