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

[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