Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id B36332E0055 for ; Mon, 26 May 2008 12:09:05 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 46141-03 for ; Mon, 26 May 2008 12:09:02 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by developer.postgresql.org (Postfix) with ESMTP id ED96A2E004D for ; Mon, 26 May 2008 12:09:01 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id m4QF8qVV021506; Mon, 26 May 2008 11:08:52 -0400 (EDT) To: "Campbell, Lance" cc: pgsql-performance@postgresql.org Subject: Re: Symbolic Links to Tablespaces In-reply-to: References: Comments: In-reply-to "Campbell, Lance" message dated "Mon, 26 May 2008 09:11:51 -0500" Date: Mon, 26 May 2008 11:08:51 -0400 Message-ID: <21505.1211814531@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200805/334 X-Sequence-Number: 30302 "Campbell, Lance" writes: > I have started to define tablespaces on different disks. Is there any > performance issues related to referencing tablespaces on different disks > with symbolic links? By using symbolic links to tablespaces can I then > stop the database and move a particular tablespace from one location to > another without causing a problem? This would seem to give a lot of > flexibility to the location of tablespaces. A tablespace already is a symbolic link --- read http://www.postgresql.org/docs/8.2/static/storage.html Putting another one into the path will eat cycles and doesn't seem like it could buy anything. regards, tom lane