Re: [GENERAL] Question about paritioning

Поиск
Список
Период
Сортировка
От Alex Samad
Тема Re: [GENERAL] Question about paritioning
Дата
Msg-id CAJ+Q1PVNS9TAB2jQka-yrN7+9wSoYf37y_ShgpxFScgq9NSJpA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [GENERAL] Question about paritioning  (John R Pierce <pierce@hogranch.com>)
Ответы Re: [GENERAL] Question about paritioning
Список pgsql-general
So is date_trunc better than to_char ? I'm thinking it probably is 

as for the number of partitions, well we don't plan on deleting anything, but from my reading as long as the queries stay on a small amount of parts that we should be okay.

A

On 27 July 2017 at 15:33, John R Pierce <pierce@hogranch.com> wrote:
On 7/26/2017 10:08 PM, Alex Samad wrote:
I have a large table about 3B rows, that I would like to partition on a column called _received which is  of type timestamp


a good goal is to have no more than about 100 partitions max, and ideally more like 25.

when we partition on time stamp, we typically do it by the week, as we're doing 6 month data retention.

IIRC, we're using DATE_TRUNC('week', timestamp)::DATE  for use as the partition label and key.



--
john r pierce, recycling bits in santa cruz



--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

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

Предыдущее
От: Krithika Venkatesh
Дата:
Сообщение: [GENERAL] Constraint exclusion involving joins
Следующее
От: Thore Boedecker
Дата:
Сообщение: Re: [GENERAL] Developer GUI tools for PostgreSQL