Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_repack solves alter table set tablespace lock - Mailing list pgsql-performance

From Josh Kupershmidt
Subject Re: pg_repack solves alter table set tablespace lock
Date
Msg-id CAK3UJRFT8rYPeMbPKOgz3XLizL-w9pgEwKW6ZtZ4ZfV=pWwcfg@mail.gmail.com
Whole thread Raw
In response to pg_repack solves alter table set tablespace lock  (Ying He <yinghe0101@yahoo.com>)
Responses Re: pg_repack solves alter table set tablespace lock  (Ying He <yinghe0101@yahoo.com>)
List pgsql-performance
Tree view

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

pgsql-performance by date:

Previous
From: Ying He
Date:
Subject: pg_repack solves alter table set tablespace lock
Next
From: Bongseo Jang
Date:
Subject: self join, parameterized base/join rel path row estimation and generally...