Re: [GENERAL] Physical Database Configuration - Mailing list pgsql-hackers

From Shridhar Daithankar
Subject Re: [GENERAL] Physical Database Configuration
Date
Msg-id 3EF9904D.26167.3160B09@localhost
Whole thread Raw
Responses Re: [GENERAL] Physical Database Configuration  (nolan@celery.tssi.com)
List pgsql-hackers
On 24 Jun 2003 at 14:48, Jonathan Bartlett wrote:

> I know the current method for specifying alternate drives for PG tables is
> by using symlinks.  I had some ideas for simple ways to do this in PG
> code, but wanted to know if anyone was working on this right now.  I'd
> hate to take the time to start messing with this if others were already on
> it.

Well, correct solution is to implement tablespaces on which objects like
databases, tables and indexes can be put.

There was a long discussion on this and there was a tablespaces patch. It was
agreed that tablespace as a set of directories would be a good point to start.

I have no idea what is the status of that effort right now. You can search the
archives or I hope this kicks a fresh discussion..:-)

Please correct me if I am wrong. I am quoting from off my head.. not a trusted
source..

Bye
 Shridhar

--
Harriet's Dining Observation:    In every restaurant, the hardness of the butter
pats    increases in direct proportion to the softness of the bread.


pgsql-hackers by date:

Previous
From: The Hermit Hacker
Date:
Subject: Re: Two weeks to feature freeze
Next
From: Joe Conway
Date:
Subject: Re: allowed user/db variables