Re: Table spaces (was Re: State of Beta 2) - Mailing list pgsql-general

From Tom Lane
Subject Re: Table spaces (was Re: State of Beta 2)
Date
Msg-id 10376.1063637662@sss.pgh.pa.us
Whole thread Raw
In response to Table spaces (was Re: State of Beta 2)  (Ron Johnson <ron.l.johnson@cox.net>)
List pgsql-general
Ron Johnson <ron.l.johnson@cox.net> writes:
> On Sun, 2003-09-14 at 23:08, Tom Lane wrote:
>> Yeah, that's been in the back of my mind also.  Once we have tablespaces
>> and a couple of the other basic features we're still missing, it might
>> be a more reasonable proposition to freeze the on-disk representation.

> I think that every effort should be made so that the on-disk struct-
> ure (ODS) doesn't have to change when tablespaces is implemented.

That's not going to happen --- tablespaces will be complex enough
without trying to support a backwards-compatible special case.

If we have a workable pg_upgrade by the time tablespaces happen, it
would be reasonable to expect it to be able to rearrange the user data
files of an existing installation into the new directory layout.  If
we don't, the issue is moot anyway.

            regards, tom lane

pgsql-general by date:

Previous
From: Cott Lang
Date:
Subject: Re: [PERFORM] best arrangement of 3 disks for (insert)
Next
From: Richard Huxton
Date:
Subject: Re: Initalizing PostgreSQL Database