From: | "Ross J(dot) Reedstrom" <reedstrm(at)rice(dot)edu> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>, Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, Peter Eisentraut <peter_e(at)gmx(dot)net>, Jan Wieck <JanWieck(at)yahoo(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Big 7.1 open items |
Date: | 2000-06-21 05:45:02 |
Message-ID: | 20000621004502.A24387@rice.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-patches |
On Wed, Jun 21, 2000 at 01:23:57AM -0400, Tom Lane wrote:
> "Hiroshi Inoue" <Inoue(at)tpf(dot)co(dot)jp> writes:
>
> > My opinion
> > 3) database and tablespace are relatively irrelevant.
> > I assume PostgreSQL's database would correspond
> > to the concept of SCHEMA.
>
> My inclindation is that tablespaces should be installation-wide, but
> I'm not completely sold on it. In any case I could see wanting a
> permissions mechanism that would only allow some databases to have
> tables in a particular tablespace.
>
> We do need to think more about how traditional Postgres databases
> fit together with SCHEMA. Maybe we wouldn't even need multiple
> databases per installation if we had SCHEMA done right.
>
The important point I think is that tablespaces are about physical
storage/namespace, and SCHEMA are about logical namespace: it would make
sense for tables from multiple schema to live in the same tablespace,
as well as tables from one schema to be stored in multiple tablespaces.
Ross
--
Ross J. Reedstrom, Ph.D., <reedstrm(at)rice(dot)edu>
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St., Houston, TX 77005
From | Date | Subject | |
---|---|---|---|
Next Message | Chris Bitmead | 2000-06-21 06:13:47 | Re: Big 7.1 open items |
Previous Message | Tom Lane | 2000-06-21 05:23:57 | Re: Big 7.1 open items |
From | Date | Subject | |
---|---|---|---|
Next Message | Chris Bitmead | 2000-06-21 06:13:47 | Re: Big 7.1 open items |
Previous Message | Tom Lane | 2000-06-21 05:23:57 | Re: Big 7.1 open items |