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 23, 2023, at 10:30 PM, Phani Prathyush Somayajula <phani.somayajula@xxxxxxxxxxxxxxxxx> wrote:
> Didn't quite get the question, Scott

I asked, what's wrong with partitioning by placedon, with a primary key of (betid, placedon). You responded that the client has some queries which group by brandid. How does adding placedon to the primary key interfere with that?

At no point have you explained how adding placedon to the primary key is a problem. I expect it is not actually a problem. It seems that you should just do what the error suggested, add placedon to the primary key.

[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