Thread: Just a small thing for 6.3 ...

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.

  Sometimes my temporary sort files grow too big, and I would love to
  be able to symlink tmp/ to another partition.


/* m */

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.

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

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