Once I have assigned tables and indexes to a particular tablespace that points to a particular location on disk is there a simple way to move the files to a new location? Example: Table xyz is using tablespace xyz_tbl which is located at /somedir/xyz_tbl on the disk. If I want to move it to a new disk located at /someotherdir/xyz_tbl/ how can I do that easily? Do I have to backup all of the tables using the tablespace xyz_tbl, drop the tables, drop the tablespace, recreate the tablespace with a different disk location and then finally reload the tables and data? Or is there an easier way? Is there a move tablespace disk location command? Thanks, Lance Campbell Project Manager/Software Architect Web Services at Public Affairs University of Illinois 217.333.0382 http://webservices.uiuc.edu My e-mail address has changed to lance@xxxxxxxxxxxx -----Original Message----- From: Tom Lane [mailto:tgl@xxxxxxxxxxxxx] Sent: Monday, May 26, 2008 10:09 AM To: Campbell, Lance Cc: pgsql-performance@xxxxxxxxxxxxxx Subject: Re: [PERFORM] Symbolic Links to Tablespaces "Campbell, Lance" <lance@xxxxxxxxxxxx> 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
