All Collections
PostgreSQL
Concepts
Which partitioning features are available in PostgreSQL?
Which partitioning features are available in PostgreSQL?
Bakul Banthia avatar
Written by Bakul Banthia
Updated over a week ago

PostgreSQL supports basic table partitioning. It supports the following partitioning features:

  • Range, List, Hash, and Sub-partitioning

  • Partition pruning - Skips unnecessary partition scans for data fetch

  • Foreign key support

You can use pg_partman to manage partitions. For example, you can pre-create a set of partitions or drop old partitions. To learn more about partitioning in PostgreSQL, see the PostgreSQL documentation.

Did this answer your question?