Re: select count() out of memory

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: select count() out of memory
Дата
Msg-id 20071025145412.GB16947@alvh.no-ip.org
обсуждение исходный текст
Ответ на Re: select count() out of memory  (tfinneid@student.matnat.uio.no)
Ответы Re: select count() out of memory
Список 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 по дате отправления:

Предыдущее
От: Reg Me Please
Дата:
Сообщение: Re: Crosstab Problems
Следующее
От: "Josh Tolley"
Дата:
Сообщение: Re: PostgreSQL and AutoCad