From: | "Mikheev, Vadim" <vmikheev(at)SECTORBASE(dot)COM> |
---|---|
To: | "'Bruce Momjian'" <pgman(at)candle(dot)pha(dot)pa(dot)us> |
Cc: | Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu>, Peter Eisentraut <peter_e(at)gmx(dot)net>, Jan Wieck <JanWieck(at)Yahoo(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, "Ross J(dot) Reedstrom" <reedstrm(at)rice(dot)edu> |
Subject: | RE: Big 7.1 open items |
Date: | 2000-06-27 19:22:13 |
Message-ID: | 8F4C99C66D04D4118F580090272A7A23018C3A@SECTORBASE1 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
> > > 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
From | Date | Subject | |
---|---|---|---|
Next Message | Mikheev, Vadim | 2000-06-27 19:31:43 | RE: Big 7.1 open items |
Previous Message | Bruce Momjian | 2000-06-27 18:18:07 | Re: Big 7.1 open items |