Re: Symbolic Links to Tablespaces - Mailing list pgsql-performance

From Tom Lane
Subject Re: Symbolic Links to Tablespaces
Date
Msg-id 21505.1211814531@sss.pgh.pa.us
Whole thread Raw
In response to Symbolic Links to Tablespaces  ("Campbell, Lance" <lance@illinois.edu>)
Responses Re: Symbolic Links to Tablespaces  ("Campbell, Lance" <lance@illinois.edu>)
List pgsql-performance
"Campbell, Lance" <lance@illinois.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

pgsql-performance by date:

Previous
From: "H. Hall"
Date:
Subject: Re: "Big O" notation for postgres?
Next
From: Tom Lane
Date:
Subject: Re: I/O on select count(*)