Re: select count() out of memory

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: tfinneid(at)student(dot)matnat(dot)uio(dot)no
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Gregory Stark <stark(at)enterprisedb(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: select count() out of memory
Date: 2007-10-25 15:32:25
Message-ID: 20071025153225.GA23566@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

tfinneid(at)student(dot)matnat(dot)uio(dot)no wrote:
> > tfinneid(at)student(dot)matnat(dot)uio(dot)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)

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2007-10-25 15:35:21 Re: select count() out of memory
Previous Message Scott Marlowe 2007-10-25 15:31:05 Re: 8.3b1 in production?