Re: Large number of partitions of a table

Поиск
Список
Период
Сортировка
От Victor Sudakov
Тема Re: Large number of partitions of a table
Дата
Msg-id YeT78eAcLCmn5zdL@admin.sibptus.ru
обсуждение исходный текст
Ответ на Re: Large number of partitions of a table  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin
Tom Lane wrote:
> Victor Sudakov <vas@sibptus.ru> writes:
> > Do you have success (or disaster) stories for having a large number of
> > partitions in a table (like maybe 10000) in a production database?
> > I've found a great article
> > https://www.depesz.com/2021/01/17/are-there-limits-to-partition-counts/
> > and basically it says 70000 partitions are OK but would like to hear
> > more opinions especially from production experience.
> 
> One thing that cannot be said too strongly is that it depends A LOT
> on which Postgres major version you are working with.  

Sorry, I should have mentioned this. I'm talking about 13.5.

-- 
Victor Sudakov VAS4-RIPE
http://vas.tomsk.ru/
2:5005/49@fidonet



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

Предыдущее
От: Ron
Дата:
Сообщение: Re: Large number of partitions of a table
Следующее
От: Victor Sudakov
Дата:
Сообщение: Re: Large number of partitions of a table