Re: What needs to be done for real Partitioning?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: What needs to be done for real Partitioning?
Дата
Msg-id 3404.1111277153@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: What needs to be done for real Partitioning?  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
Ответы Re: What needs to be done for real Partitioning?  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
Re: What needs to be done for real Partitioning?  ("Jim C. Nasby" <decibel@decibel.org>)
Список pgsql-performance
Alvaro Herrera <alvherre@dcc.uchile.cl> writes:
> We probably also need multi-table indexes.

As Josh says, that seems antithetical to the main point of partitioning,
which is to be able to rapidly remove (and add) partitions of a table.
If you have to do index cleaning before you can drop a partition, what's
the point of partitioning?

            regards, tom lane

В списке pgsql-performance по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: What needs to be done for real Partitioning?
Следующее
От: "Steinar H. Gunderson"
Дата:
Сообщение: Re: What needs to be done for real Partitioning?