Re: tablespaces in 7.5?

From: "John Sidney-Woollett" <johnsw(at)wardbrook(dot)com>
To: "Keith C(dot) Perry" <netadmin(at)vcsn(dot)com>
Cc: "Bruce Momjian" <pgman(at)candle(dot)pha(dot)pa(dot)us>, "Brian Maguire" <bmaguire(at)vantage(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: tablespaces in 7.5?
Date: 2003-12-13 09:38:25
Message-ID: 4153.192.168.0.64.1071308305.squirrel@mercury.wardbrook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

My (limited) understanding is that it will give you the ability to:

i) decide what data resides in what tablespace, (database, schema,
indexes, data [coarser -> finer grain]).
ii) where the tablespace data is physically located, allowing you to
distribute your database across disks, or disk arrays.

John Sidney-Woollett

Keith C. Perry said:
> Quoting Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>:
>
>> Brian Maguire wrote:
>> > I am curious if tablespaces are going to be seriously targeted
>> > for the next version. It really opens up new levels of scalability
>> > and is a killer feature from an administration perspective.
>>
>> I hope so!
>>
>> --
>> Bruce Momjian | http://candle.pha.pa.us
>> pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
>> + If your life is a hard drive, | 13 Roberts Road
>> + Christ can be your backup. | Newtown Square, Pennsylvania
>> 19073
>>
>> ---------------------------(end of broadcast)---------------------------
>> TIP 3: if posting/reading through Usenet, please send an appropriate
>> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
>> message can get through to the mailing list cleanly
>>
>
> Excuse my ignorance but what will namespaces give us? I though PG schema
> provided the namespace functionality- 'least the way I am understanding
> the term.
>
> --
> Keith C. Perry, MS E.E.
> Director of Networks & Applications
> VCSN, Inc.
> http://vcsn.com
>
> ____________________________________
> This email account is being host by:
> VCSN, Inc : http://vcsn.com
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
> joining column's datatypes do not match
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Brian Maguire 2003-12-13 12:50:27 Re: tablespaces in 7.5?
Previous Message Keith C. Perry 2003-12-13 09:19:46 Re: tablespaces in 7.5?