What's a reasonable maximum number for table partitions?

Поиск
Список
Период
Сортировка
От Tim Uckun
Тема What's a reasonable maximum number for table partitions?
Дата
Msg-id CAGuHJrNj+1zUyXkBNYzeyZmqNCfF8R=HzP7djTrsSJuSWpwVOQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: What's a reasonable maximum number for table partitions?  (Vick Khera <vivek@khera.org>)
Список pgsql-general
Дерево обсуждения
The documentation says having too many partitions will end up being unproductive as it will cause the optimizer to examine all the tables for query planning.  So I am wondering what's a reasonable upper limit?

If I was to partition a table by day I would have 365 tables per year. Is that too many? What if I used a different criteria that would cause a thousand tables?

Does anybody have experience with huge number of partitions if so where did you start running into trouble? 

Thanks.

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

Предыдущее
От: Pavel Stehule
Дата:
Сообщение: Re: How to hide stored procedure's bodies from specific user
Следующее
От: Alexey Bashtanov
Дата:
Сообщение: Re: How to hide stored procedure's bodies from specific user