Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 69AEA9F9BFA for ; Tue, 14 Nov 2006 20:21:15 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 78536-09 for ; Tue, 14 Nov 2006 20:21:11 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.174]) by postgresql.org (Postfix) with ESMTP id 950F29F9945 for ; Tue, 14 Nov 2006 20:21:10 -0400 (AST) Received: by ug-out-1314.google.com with SMTP id k3so5821ugf for ; Tue, 14 Nov 2006 16:21:09 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=fr/v4bVVnw2tL3Egii/khMGvoka/+bKqXrrMiTUo6hfKkCRF64Q+e74DtwzwZLRvMCs3LoKlnGqzcgYi6vuOI7B38Kr0508QNbONhg0FDnGTTh4H1l1q4jajkY+eUGxPkvSeHT4iVhLfnT6KCqiXtTTHFGJ/TraLE9MaQegio/0= Received: by 10.78.204.7 with SMTP id b7mr1670005hug.1163550068510; Tue, 14 Nov 2006 16:21:08 -0800 (PST) Received: by 10.78.139.16 with HTTP; Tue, 14 Nov 2006 16:21:08 -0800 (PST) Message-ID: Date: Tue, 14 Nov 2006 19:21:08 -0500 From: "Jaime Casanova" To: "Hakan Kocaman" Subject: Re: Move indexes Cc: "Alexander Burbello" , "Lista Postgres" In-Reply-To: <84AAD313D71B1D4F9EE20E739CC3B6ED013DF4E7@ATLANTIK-CL.intern.digame.de> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <4554CCF6.3070609@cresoltec.com.br> <84AAD313D71B1D4F9EE20E739CC3B6ED013DF4E7@ATLANTIK-CL.intern.digame.de> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200611/151 X-Sequence-Number: 23678 On 11/14/06, Hakan Kocaman wrote: > Hi, > > in short terms: > > CREATE TABLESPACE > http://www.postgresql.org/docs/8.1/interactive/sql-createtablespace.html > CREATE TABLESPACE tablespace_name [ OWNER username ] LOCATION > 'directory' > > ALTER INDEX > http://www.postgresql.org/docs/8.1/interactive/sql-alterindex.html > ALTER INDEX name SET TABLESPACE tablespace_name > > Haven't tried this for my own, so take care (and test). > i think we should add: "in >= 8.1" -- regards, Jaime Casanova "Programming today is a race between software engineers striving to build bigger and better idiot-proof programs and the universe trying to produce bigger and better idiots. So far, the universe is winning." Richard Cook