From: Ying He <yinghe0101@yahoo.com>
To: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Subject: pg_repack solves alter table set tablespace lock
Date: Fri, 24 Jan 2014 12:48:25 -0800 (PST)
Message-ID: <1390596505.28856.YahooMailNeo@web164606.mail.gq1.yahoo.com> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
hi, all,
I have a requirement to move a table to a different storage. I will
create the tablespace and use alter table set tablespace to achieve it.
The concern is that the table is pretty big and during the set
tablespace, application could insert/update/delete records. If there is a lock during the operation, it will impact db availability.
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?
For any one using pg_repack, how well does it perform?
Thank you.
best,Ying
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
Subject: Re: pg_repack solves alter table set tablespace lock
In-Reply-To: <1390596505.28856.YahooMailNeo@web164606.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