> 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. And this is the testing, so you're right.... Its only the select on the root table that fails. Operations on a single partitions is no problem. > The partitioning facility is designed for partition counts in the tens, > or maybe hundreds at the most. Maybe, but it works even on 55000 partitions as long as the operations are done against a partition and not the root table. ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend