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]


> 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)

[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]

  Powered by Linux