Plurrrr

Mon 05 Sep 2022

Postgres Partitions

There is a common misconception that partitioning a table in Postgres will improve performance, while it’s true in some cases, but sometimes partitioning may actually degrade your performance if done incorrectly.

Let me try to give a very brief overview about postgres partitioning in general and some guideline to consider before partitioning the table.

Source: Postgres Partitions, an article by John Pradeep Vincent.