Re: Partitioned table question

Поиск
Список
Период
Сортировка
От Alan Hodgson
Тема Re: Partitioned table question
Дата
Msg-id 200910141327.16585@hal.medialogik.com
обсуждение исходный текст
Ответ на Re: Partitioned table question  (Reid Thompson <reid.thompson@ateb.com>)
Список pgsql-general
On Wednesday 14 October 2009, Reid Thompson <reid.thompson@ateb.com> wrote:
> So we know have data in ~30 partitioned tables.
> Our requirements now necessitate adding some columns to all these tables
> ( done ) which will get populated via batch sql for the older tables and
> by normal processing as we move forward.
>
> The batch update is going to result in dead tuples in the older tables.
> What would be the recommended way to recover this dead space?
> Vacuum full children tables + reindex children tables?  or....
>

cluster's faster.



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

Предыдущее
От: Reid Thompson
Дата:
Сообщение: Re: Partitioned table question
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: could not open process token: error code 5