Re: Partitioned table question - Mailing list pgsql-general

From Alan Hodgson
Subject Re: Partitioned table question
Date
Msg-id 200910141327.16585@hal.medialogik.com
Whole thread Raw
In response to Re: Partitioned table question  (Reid Thompson <reid.thompson@ateb.com>)
List 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 by date:

Previous
From: Reid Thompson
Date:
Subject: Re: Partitioned table question
Next
From: Adrian Klaver
Date:
Subject: Re: could not open process token: error code 5