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

From: Arya F <arya6000(at)gmail(dot)com>
To: pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: Partitions to improve write/update speed for tables with indexes?
Date: 2020-03-23 01:22:50
Message-ID: CAFoK1azkv1Z=Rr7ZWrJjk0RQSoF6ah+QMpLSSyBs1KsEiQ3=vw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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?

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Justin Pryzby 2020-03-23 01:29:04 Re: Partitions to improve write/update speed for tables with indexes?
Previous Message Michael Lewis 2020-03-22 18:08:37 Re: JOIN on partitions is very slow