Umair Shahid takes us into partitioning strategies in PostgreSQL:
My recommended methodology for performance improvement of PostgreSQL starts with query optimization. The second step is architectural improvements, part of which is the partitioning of large tables.
Partitioning in PostgreSQL is one of those advanced features that can be a powerful performance booster. If your PostgreSQL tables are becoming very large and sluggish, partitioning might be the cure.
It’s interesting to compare this against SQL Server, where partitioning is not a strategy for query performance improvements.