Re: select count() out of memory

> Alvaro Herrera <alvherre(at)commandprompt(dot)com> writes:
>> tfinneid(at)student(dot)matnat(dot)uio(dot)no 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.