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:
@font-face {font-family:"Cambria Math"; panose-1:2 4 5 3 5 4 6 3 2 4;}@font-face {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4;}@font-face {font-family:"Book Antiqua"; panose-1:2 4 6 2 5 3 5 3 3 4;}@font-face {font-family:"Book Antiqua \,serif"; panose-1:0 0 0 0 0 0 0 0 0 0;}p.MsoNormal, li.MsoNormal, div.MsoNormal {margin:0cm; font-size:11.0pt; font-family:"Calibri",sans-serif; mso-ligatures:standardcontextual; mso-fareast-language:EN-US;}span.EmailStyle19 {mso-style-type:personal-reply; font-family:"Book Antiqua",serif; color:windowtext;}.MsoChpDefault {mso-style-type:export-only; font-size:10.0pt; mso-ligatures:none;}div.WordSection1 {page:WordSection1;}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
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.