Re: Partition By Range Without PrimaryKey : Postgresql Version 12.8 on AWS RDS

From: Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
To: Phani Prathyush Somayajula <phani(dot)somayajula(at)pragmaticplay(dot)com>
Cc: Matti Linnanvuori <matti(dot)linnanvuori(at)portalify(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 13:24:49
Message-ID: 2BE78422-2D94-424F-ACA7-1FBAA62D7F5E@elevated-dev.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

> On May 22, 2023, at 7:17 AM, Scott Ribe <scott_ribe(at)elevated-dev(dot)com> wrote:
>
> 3) don't partition on it, index (brandid, playerid, placedon)

Oops, given that you're looking for latest placedon, not a specific one, make that (placedon, playerid, brandid)

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message kaido vaikla 2023-05-22 13:44:10 Re: pg_stat_activity query_id
Previous Message Scott Ribe 2023-05-22 13:17:53 Re: Partition By Range Without PrimaryKey : Postgresql Version 12.8 on AWS RDS