From: Ying He <yinghe0101@yahoo.com>
To: Josh Kupershmidt <schmiddy@gmail.com>
Cc: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Subject: Re: pg_repack solves alter table set tablespace lock
Date: Mon, 27 Jan 2014 06:15:06 -0800 (PST)
Message-ID: <1390832106.72485.YahooMailNeo@web164602.mail.gq1.yahoo.com> (raw)
In-Reply-To: <CAK3UJRFT8rYPeMbPKOgz3XLizL-w9pgEwKW6ZtZ4ZfV=pWwcfg@mail.gmail.com>
References: <1390596505.28856.YahooMailNeo@web164606.mail.gq1.yahoo.com>
<CAK3UJRFT8rYPeMbPKOgz3XLizL-w9pgEwKW6ZtZ4ZfV=pWwcfg@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
Thank you Josh. Won't double post again. Just thought reorg mailing list is quite inactive.
best,
Ying
On Friday, January 24, 2014 4:43 PM, Josh Kupershmidt <schmiddy@gmail.com> wrote:
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: yinghe0101@yahoo.com, schmiddy@gmail.com
Subject: Re: pg_repack solves alter table set tablespace lock
In-Reply-To: <1390832106.72485.YahooMailNeo@web164602.mail.gq1.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox