tfinneid@xxxxxxxxxxxxxxxxxxxxx writes: >> In that case, why use partitions at all? They are simple independent >> tables. > For two reasons, > - the data logically belongs together. > - because its more practical to create tables as childs of a parent table > than as independent tables. > - changes to the table is applied to all partitions, and prohibits > tables with different dd. > - performing the create operation does not require the source code to > contain the ddl of the parent table. In other words, you really should have only one table; they aren't independent. What you need to do is dial down your ideas of how many partitions are reasonable to have. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match