Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1W7my2-0004xV-EH for pgsql-performance@arkaria.postgresql.org; Mon, 27 Jan 2014 14:15:15 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1W7my1-0007mQ-TN for pgsql-performance@arkaria.postgresql.org; Mon, 27 Jan 2014 14:15:13 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1W7mxz-0007jJ-Gz for pgsql-performance@postgresql.org; Mon, 27 Jan 2014 14:15:11 +0000 Received: from nm22-vm2.bullet.mail.gq1.yahoo.com ([98.136.217.65]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1W7mxw-0002Dm-5V for pgsql-performance@postgresql.org; Mon, 27 Jan 2014 14:15:10 +0000 Received: from [216.39.60.183] by nm22.bullet.mail.gq1.yahoo.com with NNFMP; 27 Jan 2014 14:15:07 -0000 Received: from [216.39.60.198] by tm19.bullet.mail.gq1.yahoo.com with NNFMP; 27 Jan 2014 14:15:07 -0000 Received: from [127.0.0.1] by omp1085.mail.gq1.yahoo.com with NNFMP; 27 Jan 2014 14:15:07 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 78077.31644.bm@omp1085.mail.gq1.yahoo.com Received: (qmail 38034 invoked by uid 60001); 27 Jan 2014 14:15:07 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1390832106; bh=3sW96iH/+8eNIZLfXAWUOgp8IGYy8PxWJNcKXwQKG6I=; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type; b=osiso6A59b4TrxnMwNW0jb6iF+5nv/Ftqo2FNhGf1blekp3nKYbOcTP1soRWYBz51q/y4e2dvgYX3yHoigP+wy0fUgD88P0gn2eDAN2vG/jKn3WKlwB/jDORyESySOgiYUA5+ZNqG78XKafmAEnjl95AtVSjYD3BfZ2OtZywOCM= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type; b=PZZD5CvhLKEoZrDmxtMLtuChhKFQRAZIrAfs/r0//zzUCWcrUEOm6JuJEbPIcI13o7ND9V0vLpTNnJWKuVzjLQNxxqicOsWvrnEfzC2aeAYd+kuIMmMjKoVVuITSMWKuKYJvWDeC/jFrvhsJcQD7jSESaBbeNDSTFDOfvjlTJ5k=; X-YMail-OSG: dVj2evUVM1n.R1UhTY3f2gIInwx7XraOVdlCVCaJ7nBtcWg raJG0fZHa41c90rwnDD2Kh6_MmtxzTw6WX100lJuTyqfAicdbtT2k1pQcX3o Ds1YAnkEwPvee1to5NJEZqTDkixoFQL6yINGKak6XEchJEkABniGU03Xovc. QyXeALl9.edYMIzDN91JnmBxoCjkua3s5_muAt3iQesBLlrl.8kbTMI4LrPG 0pRKP1DM4sngg3uZmXQLNEH4Dqsd3KOBOav6R6EGioRi02N.LwTvzQlF86IY LPuf5FvoYU7EwiOsYvk3icLmwXoZCuJDyJdSaG.uoSRjR3hyivc8GKNBJ9b2 8vbGqx83sxjUh3d9iMyZyoZKRLcd9AhM0GS2yZoGACjYbfbPAQlmz9s6nbhZ FOvHWaA0j1bYAEqqGST_jgQMbI1NPevpcrd_NOoaTa3PxmOTkNmkG_C9Cid6 EIXBh4UjjKl94NXvFtrHXAZFdV3ciDBYLRe69iHo.HLR7.rw_wRurwYx8_KN MRKWyrJEzKAeEEvJAxStXd3UWORZz1xJnfV9z_yEkV7T1KUcag.tqH58L4Jc 0zFE3OKs3cbRVL7qzlm55.sokdGmN9WHPn4P9qnNUZZjFZWRrfMQAOCAiJ0N X5kjXny4hd6Oy.aUXvk80zJrq.Cs- Received: from [72.165.157.104] by web164602.mail.gq1.yahoo.com via HTTP; Mon, 27 Jan 2014 06:15:06 PST X-Rocket-MIMEInfo: 002.001, VGhhbmsgeW91IEpvc2guIFdvbid0IGRvdWJsZSBwb3N0IGFnYWluLiBKdXN0IHRob3VnaHQgcmVvcmcgbWFpbGluZyBsaXN0IGlzIHF1aXRlIGluYWN0aXZlLgoKYmVzdCwKWWluZwoKCgoKT24gRnJpZGF5LCBKYW51YXJ5IDI0LCAyMDE0IDQ6NDMgUE0sIEpvc2ggS3VwZXJzaG1pZHQgPHNjaG1pZGR5QGdtYWlsLmNvbT4gd3JvdGU6CiAKCgpPbiBGcmksIEphbiAyNCwgMjAxNCBhdCAzOjQ4IFBNLCBZaW5nIEhlIDx5aW5naGUwMTAxQHlhaG9vLmNvbT4gd3JvdGU6CgpJIGxvb2tlZCBhdCB0aGUgcGdfcmVwYWMBMAEBAQE- X-Mailer: YahooMailWebService/0.8.174.629 References: <1390596505.28856.YahooMailNeo@web164606.mail.gq1.yahoo.com> Message-ID: <1390832106.72485.YahooMailNeo@web164602.mail.gq1.yahoo.com> Date: Mon, 27 Jan 2014 06:15:06 -0800 (PST) From: Ying He Reply-To: Ying He Subject: Re: pg_repack solves alter table set tablespace lock To: Josh Kupershmidt Cc: "pgsql-performance@postgresql.org" In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="-1048576029-1790676989-1390832106=:72485" X-Pg-Spam-Score: 0.7 (/) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org ---1048576029-1790676989-1390832106=:72485 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Thank you Josh. Won't double post again. Just thought reorg mailing list is= quite inactive.=0A=0Abest,=0AYing=0A=0A=0A=0A=0AOn Friday, January 24, 201= 4 4:43 PM, Josh Kupershmidt wrote:=0A =0A=0A=0AOn Fri,= Jan 24, 2014 at 3:48 PM, Ying He wrote:=0A=0AI look= ed at the pg_repack usage and in release 1.2 http://reorg.github.io/pg_repa= ck/. there is -s tablespace that claims to be an=0Aonline version of ALTER = TABLE ... SET TABLESPACE=0A>=0A>=0A>=0A>is this the functionality that solv= es the alter table set tablespace lock issue?=0A=0ACross-posting to multipl= e lists in quick succession is generally considered rude; I see you have po= sted to the reorg-general list already, which is the right forum for questi= ons about pg_repack. (And yes, that "-s" flag sounds like what you are afte= r.)=0A=0A=A0Josh ---1048576029-1790676989-1390832106=:72485 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable
Thank you Josh. Won't double post again. Just thought reorg m= ailing 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 H= e <yinghe0101@yahoo.com> wrote:
=0A=0A=0A<= blockquote class=3D"yiv4308378462gmail_quote" style=3D"margin:0 0 0 .8ex;bo= rder-left:1px #ccc solid;padding-left:1ex;">
=0A=0A=0A
I=0A looked at the pg_repack usage and in release 1.2 =0Ahttp://reorg.githu= b.io/pg_repack/. there is= -s tablespace that claims to=0A be an=0Aonline version of ALTER TABLE ... SET TABLESPACE

=0A=0A=0Ais 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 p= g_repack. (And yes, that "-s" flag sounds like what you are after.)
= =0A=0A=0A

 Josh


---1048576029-1790676989-1390832106=:72485--