pg_repack solves alter table set tablespace lock

From: Ying He <yinghe0101(at)yahoo(dot)com>
To: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: pg_repack solves alter table set tablespace lock
Date: 2014-01-24 20:48:25
Message-ID: 1390596505.28856.YahooMailNeo@web164606.mail.gq1.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Josh Kupershmidt 2014-01-24 21:42:42 Re: pg_repack solves alter table set tablespace lock
Previous Message Kevin Grittner 2014-01-24 20:43:46 Re: PostgreSQL 9.3.2 Performance issues