Re: [PERFORM] pg_repack solves alter table set tablespace lock

2014-01-27 Thread Alvaro Herrera
Ying He escribió: > Thank you Josh. Won't double post again. Just thought reorg mailing list is > quite inactive. Well, that tells you something about its maintenance state and what sort of help you can expect if you find yourself in trouble with it. -- Álvaro Herrerahttp://www.

Re: [PERFORM] pg_repack solves alter table set tablespace lock

2014-01-27 Thread Ying He
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 wrote: On Fri, Jan 24, 2014 at 3:48 PM, Ying He wrote: I looked at the pg_repack usage and in release 1.2 http://reorg.github.i

Re: [PERFORM] pg_repack solves alter table set tablespace lock

2014-01-24 Thread Josh Kupershmidt
On Fri, Jan 24, 2014 at 3:48 PM, Ying He 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 ta

[PERFORM] pg_repack solves alter table set tablespace lock

2014-01-24 Thread Ying He
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 dur