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?
