On Friday 23 May 2014 15:12:47 Chris Ernst wrote:
> On 05/23/2014 08:57 AM, Vincent de Phily wrote:
> > I need to reduce downtime to a minimum, so I can't afford to let "alter
> > table set tablespace" take an exclusive lock on the table for the 2h
> > it'll take to copy the data.
>
> You might lo
On 05/23/2014 08:57 AM, Vincent de Phily wrote:
> I need to reduce downtime to a minimum, so I can't afford to let "alter table
> set tablespace" take an exclusive lock on the table for the 2h it'll take to
> copy the data.
You might look at pg_repack (https://github.com/reorg/pg_repack). The
m
Vincent de Phily writes:
> Hi list,
>
>
> I'm in the process of moving some tables to a new tablespace ahead of disk
> space issues. I'm on PG 9.1, using streaming replication.
>
> I need to reduce downtime to a minimum, so I can't afford to let "alter table
> set tablespace" take an exclusive
