Re: select count() out of memory

tfinneid@student.matnat.uio.no 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