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

Поиск
Список
Период
Сортировка
От Scott Ribe
Тема Re: Partition By Range Without PrimaryKey : Postgresql Version 12.8 on AWS RDS
Дата
Msg-id 3ACB6DC6-E93B-45ED-B571-993A7190DEC1@elevated-dev.com
обсуждение исходный текст
Ответ на Partition By Range Without PrimaryKey : Postgresql Version 12.8 on AWS RDS  (Phani Prathyush Somayajula <phani.somayajula@pragmaticplay.com>)
Список pgsql-admin
> On May 23, 2023, at 10:30 PM, Phani Prathyush Somayajula <phani.somayajula@pragmaticplay.com> 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
clienthas 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. 


В списке pgsql-admin по дате отправления:

Предыдущее
От: Scott Ribe
Дата:
Сообщение: Re: Partition By Range Without PrimaryKey : Postgresql Version 12.8 on AWS RDS
Следующее
От: Ravi GH
Дата:
Сообщение: PG Database Encryption