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
>
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? |