Partitions to improve write/update speed for tables with indexes?

Поиск
Список
Период
Сортировка
От Arya F
Тема Partitions to improve write/update speed for tables with indexes?
Дата
Msg-id CAFoK1azkv1Z=Rr7ZWrJjk0RQSoF6ah+QMpLSSyBs1KsEiQ3=vw@mail.gmail.com
обсуждение исходный текст
Ответы Re: Partitions to improve write/update speed for tables with indexes?  (Justin Pryzby <pryzby@telsasoft.com>)
Список pgsql-performance
Дерево обсуждения 
I have noticed that my write/update performance starts to dramatically
reduce after about 10 million rows on my hardware. The reason for the
slowdown is the index updates on every write/update.

The solution would be partitioning? One of my tables will have more
than 1 billion rows of data, so I would have to create about 100
partitions for that table. Is the a practical limit to the amount of
partitions I can have with Postgresql 12?

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

Предыдущее
От: Michael Lewis
Дата:
Сообщение: Re: JOIN on partitions is very slow
Следующее
От: Justin Pryzby
Дата:
Сообщение: Re: Partitions to improve write/update speed for tables with indexes?