"Campbell, Lance" <lance(at)illinois(dot)edu> 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