From: | Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp> |
---|---|
To: | Zeugswetter Andreas SB <ZeugswetterA(at)wien(dot)spardat(dot)at> |
Cc: | "'Mikheev, Vadim'" <vmikheev(at)SECTORBASE(dot)COM>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: AW: Big 7.1 open items |
Date: | 2000-06-28 10:47:43 |
Message-ID: | 3959D7CF.E447565@tpf.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Zeugswetter Andreas SB wrote:
> > > > > The symlinks wouldn't do any good for what Bruce had in
> > > > > mind anyway (IIRC, he wanted to get useful per-database
> > > > > numbers from "du").
> > > >
> > > > Our database design seems to be in the opposite direction
> > > > if it is restricted for the convenience of command calls.
> > >
> > > Well, I don't see any reason not to use tablespace/database
> > > rather than just tablespace. Seems having fewer files in
> > each directory
> >
> > Once again - ability to use different tablespaces (disks) for
> > tables/indices
> > in the same schema. Schemas must not dictate where to store objects <-
> > bad design.
>
> Can we agree, that the schema is below the database hierarchy, and thus
> is something different than a database ?
I don't think we have a common understanding for PG's *database*
(created by createdb). Every one seems to have his own *database*.
According to your another posting,your *database* hierarchy is
instance -> database -> schema -> object
like Oracle.
However SQL92 seems to have another hierarchy:
cluster -> catalog -> schema -> object
and dot notation catalog.schema.object could be used.
I couldn't find clear correspondense between PG's *database*
and above hierarchy because we have no dot notation for
objects currently.
>
> A table under another schema will simply get another oid, and thus no
> collision.
> But I agree that schema should not dictate storage location,
> but the schema might imply a default storage location like in Oracle
> (default tablespaces for a user).
AFAIK,schema is independent from user in SQL92.
So default_tablespace_per_user doesn't necessarily imply
default_tablespace_per_schema.
Regards.
Hiroshi Inoue
From | Date | Subject | |
---|---|---|---|
Next Message | Zeugswetter Andreas SB | 2000-06-28 12:07:33 | AW: AW: Big 7.1 open items |
Previous Message | Zeugswetter Andreas SB | 2000-06-28 09:11:35 | AW: Big 7.1 open items |