From: | Phani Prathyush Somayajula <phani(dot)somayajula(at)pragmaticplay(dot)com> |
---|---|
To: | Ron <ronljohnsonjr(at)gmail(dot)com>, "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org> |
Subject: | RE: Partition By Range Without PrimaryKey : Postgresql Version 12.8 on AWS RDS |
Date: | 2023-05-22 07:08:07 |
Message-ID: | VI1PR10MB76716165F4E9041CC048168E8D439@VI1PR10MB7671.EURPRD10.PROD.OUTLOOK.COM |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
If I had the partition column in my PK, other services using this table, are affected adversely – that’s the catch.
Apologies for not being completely transparent.
Regards,
Phani Pratz
PPBET-DBA
From: Ron <ronljohnsonjr(at)gmail(dot)com>
Sent: Monday, May 22, 2023 12:34 PM
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: Partition By Range Without PrimaryKey : Postgresql Version 12.8 on AWS RDS
On 5/22/23 01:53, Phani Prathyush Somayajula wrote:
Hi All,
I’ve a table ermabet having 80mil records. My business need is to check the bet placed by a player(users), which queries the table, and enable streaming for the player only if he has placed his bet in the last 24 hrs( granular to the millisecond).
[snip]
But I don’t want PLACEDON column part of the primary key.
And I didn't want partition_date in my PK, either, but I had to add so as to partition on the part_date column.
--
Born in Arizona, moved to Babylonia.
From | Date | Subject | |
---|---|---|---|
Next Message | Phani Prathyush Somayajula | 2023-05-22 07:10:14 | RE: Partition By Range Without PrimaryKey : Postgresql Version 12.8 on AWS RDS |
Previous Message | Ron | 2023-05-22 07:07:20 | Re: Partition By Range Without PrimaryKey : Postgresql Version 12.8 on AWS RDS |