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 C995B307-FB34-46AD-99FA-392FAD216D4B@elevated-dev.com
обсуждение исходный текст
Ответ на RE: 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 2:46 AM, Phani Prathyush Somayajula <phani.somayajula@pragmaticplay.com> wrote:
>
> What's wrong with partitioning by placedon, with a primary key of (betid, placedon)? - this is because the business
needto run group by queries based on these brands. For now, there are 4 brands and in future it could go up to 7. 

How does a primary key of (betid, placedon) instead of betid interfere with that?

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

Предыдущее
От: Phani Prathyush Somayajula
Дата:
Сообщение: 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