Re: identify partitioning columns and best practices of partitioning in prod enviornments

Поиск
Список
Период
Сортировка
От Ron
Тема Re: identify partitioning columns and best practices of partitioning in prod enviornments
Дата
Msg-id 921baf8a-195b-fb45-292f-2618f5088302@gmail.com
обсуждение исходный текст
Ответ на identify partitioning columns and best practices of partitioning in prod enviornments  (Atul Kumar <akumar14871@gmail.com>)
Ответы Re: identify partitioning columns and best practices of partitioning in prod enviornments  (Michael Lewis <mlewis@entrata.com>)
Список pgsql-general
Дерево обсуждения 
On 11/11/20 4:31 PM, Atul Kumar wrote:
> Hi,
>
> I want to about best practices of partitioning in prod environments
> and how to identify partitioning columns.

It depends on what you want to do.  If your purpose is to simplify the 
deletion of old records, then partition by an unchanging date field.
If your purpose is to increase locality of data (because many of your 
queries are an equality on a specific "group id"), then partition by that 
"group id" field.


-- 
Angular momentum makes the world go 'round.

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

Предыдущее
От: Atul Kumar
Дата:
Сообщение: identify partitioning columns and best practices of partitioning in prod enviornments
Следующее
От: Michael Lewis
Дата:
Сообщение: Re: identify partitioning columns and best practices of partitioning in prod enviornments