The Hermit Hacker wrote:
>
> On Wed, 14 Jan 1998, Mattias Kregert wrote:
>
> > May I suggest a minor change?
> >
> > - "Keep the directory tidy"
> >
> > The "data/base/*/" directories looks awful, almost as bad as the
> > c:\windows dir on my dos partition... ;-) All types of files are
> > just thrown in, without any structure. It would be nice if the
> > files were put into separate subdirs:
> > data/base/mydb/{systables,tables,indexes,sequences,tmp} etc.
We told about TABLESPACE concept...
> I like to be able to do an 'ls -lt' on the directory to watch
> vacuum's process, so don't really like this idea, except the idea of
You'll be able to do this - vacuum' lock file will be placed in .../mydb
when vacuuming any table from any tablespace.
> moving the tmp files into a seperate subdirectory, as you are right, being
> able to "move" just the temp file creation to a seperate area would be
> nice
You are able to define tmp-dir at compile time right now...
Vadim