Re: pg_repack solves alter table set tablespace lock
Josh Kupershmidt <schmiddy@gmail.com>
From: Josh Kupershmidt <schmiddy@gmail.com>
To: Ying He <yinghe0101@yahoo.com>
Cc: "pgsql-performance@postgresql.org" <pgsql-performance@postgresql.org>
Date: 2014-01-24T21:42:42Z
Lists: pgsql-performance
On Fri, Jan 24, 2014 at 3:48 PM, Ying He <yinghe0101@yahoo.com> 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