Thread

1. pg_repack solves alter table set tablespace lock

   yhe <yinghe0101@yahoo.com> — 2014-01-24T20:48:25Z

   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

2. Re: pg_repack solves alter table set tablespace lock

   Josh Kupershmidt <schmiddy@gmail.com> — 2014-01-24T21:42:42Z

   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
   

3. Re: pg_repack solves alter table set tablespace lock

   yhe <yinghe0101@yahoo.com> — 2014-01-27T14:15:06Z

   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

4. Re: pg_repack solves alter table set tablespace lock

   Alvaro Herrera <alvherre@2ndquadrant.com> — 2014-01-27T14:24:54Z

   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 Herrera                http://www.2ndQuadrant.com/
   PostgreSQL Development, 24x7 Support, Training & Services