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

Vadim B. Mikheev <vadim@sable.krasnoyarsk.su>

From: "Vadim B. Mikheev" <vadim@sable.krasnoyarsk.su>
To: The Hermit Hacker <scrappy@hub.org>
Cc: Mattias Kregert <matti@algonet.se>, pgsql-hackers@postgreSQL.org
Date: 1998-01-15T04:01:52Z
Lists: pgsql-hackers
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