Postgres Pro
Downloads
Home   >   mailing lists

Symbolic Links to Tablespaces - Mailing list pgsql-performance

From Campbell, Lance
Subject Symbolic Links to Tablespaces
Date
Msg-id B10E6810AC2A2F4EA7550D072CDE8760CDDD7B@SAB-FENWICK.sab.uiuc.edu
Whole thread Raw
Responses Re: Symbolic Links to Tablespaces  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
Tree view

PostgreSQL: 8.2.X

OS: Red Hat Linux 4.X

 

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. 

 

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@illinois.edu

 

pgsql-performance by date:

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