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

From Alvaro Herrera
Subject Re: select count() out of memory
Date
Msg-id 20071025153225.GA23566@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:
> > tfinneid@student.matnat.uio.no wrote:
> > It will work on a million partitions and more, provided you do
> > operations on single partitions.
>
> Thats good enough for me, thats exactly what I want.

In that case, why use partitions at all?  They are simple independent
tables.

--
Alvaro Herrera                               http://www.PlanetPostgreSQL.org/
"El destino baraja y nosotros jugamos" (A. Schopenhauer)

pgsql-general by date:

Previous
From: "Scott Marlowe"
Date:
Subject: Re: 8.3b1 in production?
Next
From: Alvaro Herrera
Date:
Subject: Re: select count() out of memory