From: Ron <ronljohnsonjr@gmail.com>
To: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Subject: Re: Partition By Range Without PrimaryKey : Postgresql Version 12.8 on AWS RDS
Date: Mon, 22 May 2023 02:13:29 -0500
Message-ID: <a4d46fae-5395-935c-eec4-cd4c8d956948@gmail.com> (raw)
In-Reply-To: <VI1PR10MB76716165F4E9041CC048168E8D439@VI1PR10MB7671.EURPRD10.PROD.OUTLOOK.COM>
References: <VI1PR10MB76711B1B17D38E3CFF4E73008D439@VI1PR10MB7671.EURPRD10.PROD.OUTLOOK.COM>
<a9aa4d47-9db8-0da8-641c-67ea8fbe893c@gmail.com>
<VI1PR10MB76716165F4E9041CC048168E8D439@VI1PR10MB7671.EURPRD10.PROD.OUTLOOK.COM>
Adverse affects, huh? Us, too. Had to departition quite a few tables for
performance reasons.
Honestly, 80M rows isn't a lot, *unless* those jsonb fields are big.
Question whether you /need/ to partition the table.
On 5/22/23 02:08, Phani Prathyush Somayajula wrote:
>
> 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@gmail.com>
> *Sent:* Monday, May 22, 2023 12:34 PM
> *To:* pgsql-admin@lists.postgresql.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.
>
--
Born in Arizona, moved to Babylonia.
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: ronljohnsonjr@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: Partition By Range Without PrimaryKey : Postgresql Version 12.8 on AWS RDS
In-Reply-To: <a4d46fae-5395-935c-eec4-cd4c8d956948@gmail.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