Thread

1. Re: [HACKERS] Just a small thing for 6.3 ...

   Marc G. Fournier <scrappy@hub.org> — 1998-01-14T17:01:15Z

   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
   
   
   

2. Just a small thing for 6.3 ...

   Mattias Kregert <matti@algonet.se> — 1998-01-14T17:02:01Z

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

3. Re: [HACKERS] Just a small thing for 6.3 ...

   Thomas Lockhart <lockhart@alumni.caltech.edu> — 1998-01-15T02:06:05Z

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

4. Re: [HACKERS] Just a small thing for 6.3 ...

   Vadim B. Mikheev <vadim@sable.krasnoyarsk.su> — 1998-01-15T04:01:52Z

   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