Re: pg_repack solves alter table set tablespace lock

From: Josh Kupershmidt <schmiddy(at)gmail(dot)com>
To: Ying He <yinghe0101(at)yahoo(dot)com>
Cc: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: pg_repack solves alter table set tablespace lock
Date: 2014-01-24 21:42:42
Message-ID: CAK3UJRFT8rYPeMbPKOgz3XLizL-w9pgEwKW6ZtZ4ZfV=pWwcfg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Fri, Jan 24, 2014 at 3:48 PM, Ying He <yinghe0101(at)yahoo(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message RAMAKRISHNAN KANDASAMY 2014-01-25 06:32:59 PostgreSQL 9.3.2 Performance tuning for 32 GB server
Previous Message Ying He 2014-01-24 20:48:25 pg_repack solves alter table set tablespace lock