Create PostgreSQL Table Partitioning (Part 1) - Comment Page: 1

PostgreSQL supports partitioning via table inheritance. So the partitioning is made in such a way that every child table inherits single parent table. Parent table is empty and it exists just to describe the whole data set. PostgreSQL partitioning can be implemented in range partitioning or list partitioning. Range partitioning can be done for example by ID ranges (like 0-100 000, 100 001-200 000, 200 001-300 000...) or Date ranges (like 2009-11-01 - 2009-11-30, 2009-12-01 - 2009-12-31...). List partitioning can be done for example by list of cities (like New York, Los Angeles, Chicago, Houston, Philadelphia...) or list of categories (like Programming, Home, Food...). It's...