Re: select count() out of memory - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: select count() out of memory
Date
Msg-id 20071025145412.GB16947@alvh.no-ip.org
Whole thread Raw
In response to Re: select count() out of memory  (tfinneid@student.matnat.uio.no)
Responses Re: select count() out of memory  (tfinneid@student.matnat.uio.no)
List pgsql-general
tfinneid@student.matnat.uio.no wrote:
> > Alvaro Herrera <alvherre@commandprompt.com> writes:

> > 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.

It will work on a million partitions and more, provided you do
operations on single partitions.

What you want to do is not possible, period.  Maybe when we redesign
partitioning, but that's far into the future.  Kindly do not waste our
time (nor yours).

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

pgsql-general by date:

Previous
From: Reg Me Please
Date:
Subject: Re: Crosstab Problems
Next
From: "Josh Tolley"
Date:
Subject: Re: PostgreSQL and AutoCad