Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 5BDB49FB2F4 for ; Mon, 5 Feb 2007 16:29:18 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 02967-01 for ; Mon, 5 Feb 2007 16:29:11 -0400 (AST) X-Greylist: delayed 00:06:40.931576 by SQLgrey-1.7.4 Received: from web60724.mail.yahoo.com (web60724.mail.yahoo.com [209.73.178.212]) by postgresql.org (Postfix) with SMTP id BD7339FB2C9 for ; Mon, 5 Feb 2007 16:29:13 -0400 (AST) Received: (qmail 53023 invoked by uid 60001); 5 Feb 2007 20:22:31 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com.br; h=X-YMail-OSG:Received:X-Mailer:Date:From:Reply-To:Subject:To:Cc:MIME-Version:Content-Type:Message-ID; b=4OueJg7l8pOYyL1pCLOGEi+B2/2+KLzeGMM8F0JvBsQdFfhJUbP/P/CTrPUhx4LxyjTvr+VWMyxqscD7ze/TIWTrKAX1JvSW6sjCavh/3IRTxjUZZL0LUPE+v7cMxDrKCx6oZmPrMDKbec/y95Eotku1OJgRHF0bnJeOfEVvYfU=; X-YMail-OSG: z.Ini64VM1nuaeEM.7ghVkzxgq2T4YsSTpmvPWgSaIwCVTqCf2N.fhxNqK0bvH2HU32R_glbq1._swtFl3fO7Y5rv.uuZCB2EswmvsymW1WBh20iBXY5JXbK_tPRDKLen7ct2sEtrBb7_UBC Received: from [201.51.206.152] by web60724.mail.yahoo.com via HTTP; Mon, 05 Feb 2007 12:22:31 PST X-Mailer: YahooMailRC/368.3 YahooMailWebService/0.6.132.7 Date: Mon, 5 Feb 2007 12:22:31 -0800 (PST) From: Mario Reply-To: Mario Subject: Res: Moving a table to another directory To: "Milen A. Radev" Cc: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-1019661279-1170706951=:50714" Message-ID: <435775.50714.qm@web60724.mail.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.698 tagged_above=0 required=5 tests=BAYES_50, DNS_FROM_RFC_ABUSE, HTML_40_50, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200702/62 X-Sequence-Number: 24527 --0-1019661279-1170706951=:50714 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable boa tarde,=0A=0Acomo fa=C3=A7o para retirar meu emaio dessa lista de discur= ssao...=0A=0Ase alguem puder me ajudar agrade=C3=A7o=0A=0Aobrigado=0A=0A=0A= =0A=0A=0A=0A=0A=0A=0A=0A=0A=0A----- Mensagem original ----=0ADe: Milen A. R= adev =0APara: pgsql-admin@postgresql.org=0AEnviadas: Segun= da-feira, 5 de Fevereiro de 2007 18:14:16=0AAssunto: Re: [ADMIN] Moving a t= able to another directory=0A=0A=0AEzequiel Luis Pellettieri =D0=BD=D0=B0=D0= =BF=D0=B8=D1=81=D0=B0:=0A> Hi guys I have a big table (25 gb) and a need to= move it to another=0A> directory cos i'm out of space.=0A> making a symlik= will be ok? or I have to do something else=0A> =0A=0A=0A1. CREATE TABLESPA= CE xxx LOCATION 'another_dir'=0A(http://www.postgresql.org/docs/current/sta= tic/sql-createtablespace.html);=0A=0A2. ALTER TABLE big_table SET TABLESPAC= E xxx;=0A(http://www.postgresql.org/docs/current/static/sql-altertable.html= )=0A=0A=0A-- =0AMilen A. Radev=0A=0A=0A---------------------------(end of b= roadcast)---------------------------=0ATIP 6: explain analyze is your frien= d=0A=0A__________________________________________________=0AFale com seus a= migos de gra=C3=A7a com o novo Yahoo! Messenger =0Ahttp://br.messenger.yah= oo.com/ --0-1019661279-1170706951=:50714 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable
=0A

 
=0A
boa tarde,
= =0A
 
=0A
como fa=C3=A7o para retirar meu emaio dessa lis= ta de discurssao...
=0A
 
=0A
se alguem puder me aju= dar agrade=C3=A7o
=0A
 
=0A
obrigado
=0A
=0A

=0A

= =0A
=0A


 

=0A


=0A
-----= Mensagem original ----
De: Milen A. Radev <milen@radev.net>
Pa= ra: pgsql-admin@postgresql.org
Enviadas: Segunda-feira, 5 de Fevereiro d= e 2007 18:14:16
Assunto: Re: [ADMIN] Moving a table to another directory=

=0A
Ezequiel Luis Pellettieri =D0=BD=D0=B0=D0=BF=D0=B8=D1=81=D0= =B0:
> Hi guys I have a big table (25 gb) and a need to move it to an= other
> directory cos i'm out of space.
> making a symlik will = be ok? or I have to do something else
>


1. CREATE TABLESP= ACE xxx LOCATION 'another_dir'
(http://www.post= gresql.org/docs/current/static/sql-createtablespace.html);

2. AL= TER TABLE big_table SET TABLESPACE xxx;
(http://www.p= ostgresql.org/docs/current/static/sql-altertable.html)


-- Milen A. Radev


---------------------------(end of broadcast)--= -------------------------
TIP 6: explain analyze is your friend


__________________________________________________Fale com seus amigos de gra=C3=A7a com o novo Yahoo! Messenger
http://br.messenger.yahoo.com/ --0-1019661279-1170706951=:50714--