Re: Table spaces again [was Re: Threaded Sorting]

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: hs(at)cybertec(dot)at
Cc: shridhar_daithankar(at)persistent(dot)co(dot)in, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Table spaces again [was Re: Threaded Sorting]
Date: 2002-10-07 15:14:13
Message-ID: 23825.1034003653@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

=?ISO-8859-1?Q?Hans-J=FCrgen_Sch=F6nig?= <postgres(at)cybertec(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2002-10-07 15:21:57 Re: [pgsql-performance] Large databases, performance
Previous Message Shridhar Daithankar 2002-10-07 15:01:16 Re: Table spaces again [was Re: Threaded Sorting]