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?