| 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 14:54:12 |
| Message-ID: | 20071025145412.GB16947@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:
> > Alvaro Herrera <alvherre(at)commandprompt(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Erik Jones | 2007-10-25 14:56:33 | Re: select count() out of memory |
| Previous Message | Reg Me Please | 2007-10-25 14:46:26 | Re: Crosstab Problems |