> > > 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

Tue, 27 Jun 2000 12:22:13 -0700
"Mikheev, Vadim" <vmikheev@SECTORBASE.COM>
RE: Big 7.1 open items
> > 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.
> ^^^^^^^^^^^

Sorry, I should have said a symlink sits in data/base and points to the
tablespace.  My issue is having it point to tablespace/database and not
just tablespace/.

> 
> Didn't you mean 
> 
> ln -s /var/myspace/testdb data/base/testdb/myspace
> 

No, sorry for the confusion.


> ?
> 
> 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").

No, I want symlinks in data/base.  What I wanted was to have
per-database directories in every tablespace so I can do a 'du' in the
tablespace directory to see how much of each database is the tablespace.
It also nicely partitions the files, makes the directories smaller, and
prevents any possible file name conflict.

-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Tue, 27 Jun 2000 15:34:42 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: Big 7.1 open items