Bruce Momjian <pgman@candle.pha.pa.us> writes:
> Well, that would allow us to mix database files in the same directory,
> if we wanted to do that. My opinion it is better to keep databases in
> separate directories in each tablespace for clarity and performance
> reasons.
One reason not to do that is that we'd still have to special-case
the system-wide relations. If it's just tablespace and OID in the
path, then the system-wide rels look just the same as any other rel
as far as the low-level stuff is concerned. That would be nice.
My feeling about the "clarity and performance" issue is that if a
dbadmin wants to keep track of database contents separately, he can
put different databases' tables into different tablespaces to start
with. If he puts several tables into one tablespace, he's saying
he doesn't care about distinguishing their space usage. There's
no reason for us to force an additional level of directory lookup
to be done whether the admin wants it or not.
regards, tom lane