Re: Table spaces again [was Re: Threaded Sorting] - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Table spaces again [was Re: Threaded Sorting]
Date
Msg-id 23825.1034003653@sss.pgh.pa.us
Whole thread Raw
In response to Re: Table spaces again [was Re: Threaded Sorting]  (Hans-Jürgen Schönig <postgres@cybertec.at>)
Responses Re: Table spaces again [was Re: Threaded Sorting]  ("Jim Buttafuoco" <jim@contactbda.com>)
List pgsql-hackers
Hans-Jürgen Schönig <postgres@cybertec.at> writes:
> how would you handle table spaces?

The plan that's been discussed simply defines a tablespace as being a
directory somewhere; physical storage of individual tables would remain
basically the same, one or more files under the containing directory.

The point of this being, of course, that the DBA could create the
tablespace directories on different partitions or volumes in order to
provide the behavior he wants.

In my mind this would be primarily a cleaner, more flexible
reimplementation of the existing "database location" feature.
        regards, tom lane


pgsql-hackers by date:

Previous
From: "Shridhar Daithankar"
Date:
Subject: Re: Table spaces again [was Re: Threaded Sorting]
Next
From: Manfred Koizar
Date:
Subject: Re: [GENERAL] Large databases, performance