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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: Phani Prathyush Somayajula <phani.somayajula@xxxxxxxxxxxxxxxxx>
Subject: Re: Partition By Range Without PrimaryKey : Postgresql Version 12.8 on AWS RDS
From: Scott Ribe <scott_ribe@xxxxxxxxxxxxxxxx>
Date: Mon, 22 May 2023 07:24:49 -0600
Cc: Matti Linnanvuori <matti.linnanvuori@xxxxxxxxxxxxx>, "pgsql-admin@xxxxxxxxxxxxxxxxxxxx" <pgsql-admin@xxxxxxxxxxxxxxxxxxxx>
In-reply-to: <9558F0D3-4B5B-4CE2-A27F-156149E75916@elevated-dev.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>

> On May 22, 2023, at 7:17 AM, Scott Ribe <scott_ribe@xxxxxxxxxxxxxxxx> 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)

Follow-Ups:
- RE: Partition By Range Without PrimaryKey : Postgresql Version 12.8 on AWS RDS
  - From: Phani Prathyush Somayajula

References:
- Partition By Range Without PrimaryKey : Postgresql Version 12.8 on AWS RDS
  - From: Phani Prathyush Somayajula
- RE: Partition By Range Without PrimaryKey : Postgresql Version 12.8 on AWS RDS
  - From: Phani Prathyush Somayajula
- Re: Partition By Range Without PrimaryKey : Postgresql Version 12.8 on AWS RDS
  - From: Matti Linnanvuori
- RE: Partition By Range Without PrimaryKey : Postgresql Version 12.8 on AWS RDS
  - From: Phani Prathyush Somayajula
- Re: Partition By Range Without PrimaryKey : Postgresql Version 12.8 on AWS RDS
  - From: Scott Ribe

Prev by Date: Re: Partition By Range Without PrimaryKey : Postgresql Version 12.8 on AWS RDS
Next by Date: Re: pg_stat_activity query_id
Previous by thread: Re: Partition By Range Without PrimaryKey : Postgresql Version 12.8 on AWS RDS
Next by thread: RE: Partition By Range Without PrimaryKey : Postgresql Version 12.8 on AWS RDS
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Home] [Postgresql General] [Postgresql Performance] [Postgresql PHP] [Postgresql Jobs] [PHP Users] [PHP Databases] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Databases] [Yosemite Forum]