Re: pg_repack solves alter table set tablespace lock

Josh Kupershmidt <schmiddy@xxxxxxxxx> · Fri, 24 Jan 2014 16:42:42 -0500

On Fri, Jan 24, 2014 at 3:48 PM, Ying He <yinghe0101@xxxxxxxxx> wrote:

I
 looked at the pg_repack usage and in release 1.2 
http://reorg.github.io/pg_repack/. there is -s tablespace that claims to
 be an
online version of ALTER TABLE ... SET TABLESPACE

is this the functionality that solves the alter table set tablespace lock issue?

Cross-posting to multiple lists in quick succession is generally considered rude; I see you have posted to the reorg-general list already, which is the right forum for questions about pg_repack. (And yes, that "-s" flag sounds like what you are after.)

 Josh