> > Do we need *both* database & tablespace to find table file ?!
> > Imho, database shouldn't be used...
>
> That'd work fine for me, but I think Bruce was arguing for paths that
> included the database name. We'd end up with paths that go something
> like
> ..../data/tablespaces/TABLESPACEOID/RELATIONOID
> (plus some kind of decoration for segment and version), so you'd have
> a hard time telling which files in a tablespace belong to which
> database. Doesn't bother me a whole lot, personally --- if one wants
We could create /data/databases/DATABASEOID/ and create soft-links to
table-files. This way different tables of the same database could be in
different tablespaces. /data/database path would be used in production
and /data/tablespace path would be used in recovery.
Vadim