Alvaro Herrera <alvherre@xxxxxxxxxxxxxxxxx> writes: > tfinneid@xxxxxxxxxxxxxxxxxxxxx wrote: >> I did a test previously, where I created 1 million partitions (without >> data) and I checked the limits of pg, so I think it should be ok. > Clearly it's not. You couldn't have tested it too much --- even planning a query over so many tables would take forever, and actually executing it would surely have run the system out of locktable space before it even started scanning. The partitioning facility is designed for partition counts in the tens, or maybe hundreds at the most. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
