> > 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.
>
> 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
> 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
The system would have to keep track of which kinds of things are temporary
and which are permanent. This might be easier to do once we start
implementing the session- and transaction-only definitions in SQL92. Not
there for v6.3...
- Tom