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 look at
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 lock on the table for the 2h it'll take
Vincent de Phily vincent.deph...@mobile-devices.fr 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
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
most