> > > 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.
>
> I am suggesting this symlink:
>
> ln -s data/base/testdb/myspace /var/myspace/testdb
>
> rather than:
>
> ln -s data/base/testdb/myspace /var/myspace
>
> Tablespaces still sit inside database directories, it is just that it
> points to a subdirectory of myspace, rather than myspace itself.
^^^^^^^^^^^
Didn't you mean
ln -s /var/myspace/testdb data/base/testdb/myspace
?
I thought that you don't like symlinks from data/base/... This is
how I understood Tom' words:
> 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").
Vadim