From: | "Philip J(dot) Warner" <pjw(at)rhyme(dot)com(dot)au> |
---|---|
To: | "Hiroshi Inoue" <Inoue(at)tpf(dot)co(dot)jp>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Bruce Momjian" <pgman(at)candle(dot)pha(dot)pa(dot)us> |
Cc: | "Jan Wieck" <JanWieck(at)yahoo(dot)com>, "Ross J(dot) Reedstrom" <reedstrm(at)rice(dot)edu>, "Don Baccus" <dhogaza(at)pacifier(dot)com>, "PostgreSQL-development" <pgsql-hackers(at)postgreSQL(dot)org> |
Subject: | RE: Big 7.1 open items |
Date: | 2000-06-21 01:22:10 |
Message-ID: | 3.0.5.32.20000621112210.01d97680@mail.rhyme.com.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-patches |
At 05:59 21/06/00 +0900, Hiroshi Inoue wrote:
>
>Before the details of tablespace implementation,
>
>1) How to change(extend) the syntax of CREATE TABLE
> We only add table(data)space name with some
> keyword ? i.e Do we consider tablespace as an
> abstraction ?
>
It may be worth considering leaving the CREATE TABLE statement alone.
Dec/RDB uses a new statement entirely to define where a table goes. It's
actually a *very* complex statement, but the key syntax is:
CREATE STORAGE MAP <map-name> FOR <table-name>
[PLACEMENT VIA INDEX <index-name>]
STORE [COLUMNS ([col-name,])]
[IN <area-name>
| RANDOMLY ACROSS <area-list>]
;
where <area-name> is the name of a Dec/RDB STORAGE AREA, which is basically
a file that contains one or more tables/indices etc. There are options to
specify area choice by column value, fullness, how to store BLOBs etc etc.
I realize that this is way too complex for a first pass, but it gives an
idea of where you *might* want to go, and hence, possibly, a reason for
starting out with something like:
CREATE STORAGE MAP <map-name> for <table-name> STORE IN <area-name>;
P.S. I really hope this is more cogent than my last message.
----------------------------------------------------------------
Philip Warner | __---_____
Albatross Consulting Pty. Ltd. |----/ - \
(A.C.N. 008 659 498) | /(@) ______---_
Tel: (+61) 0500 83 82 81 | _________ \
Fax: (+61) 0500 83 82 82 | ___________ |
Http://www.rhyme.com.au | / \|
| --________--
PGP key available upon request, | /
and from pgp5.ai.mit.edu:11371 |/
From | Date | Subject | |
---|---|---|---|
Next Message | Chris Bitmead | 2000-06-21 02:27:45 | Re: Big 7.1 open items |
Previous Message | Hiroshi Inoue | 2000-06-20 23:54:51 | RE: Big 7.1 open items |
From | Date | Subject | |
---|---|---|---|
Next Message | Chris Bitmead | 2000-06-21 02:27:45 | Re: Big 7.1 open items |
Previous Message | Hiroshi Inoue | 2000-06-20 23:54:51 | RE: Big 7.1 open items |