Postgres Pro
Downloads
Home   >   mailing lists

Re: creating an index with tablespace on a dedicated filesystem (postgresql 8.1.5) - Mailing list pgsql-general

From Vlad
Subject Re: creating an index with tablespace on a dedicated filesystem (postgresql 8.1.5)
Date
Msg-id cd70c6810612140648y63f091c2y3ec12386fb7d8759@mail.gmail.com
Whole thread Raw
In response to Re: creating an index with tablespace on a dedicated filesystem (postgresql 8.1.5)  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
so I guess for performance sake it makes sense do that under

$TABLESPACEPATH/yourdb/pgsql_tmp/

in case $TABLESPACEPATH for the object is being created is set to a
non-default value

>
> Temp files are created in $PGDATA/base/yourdb/pgsql_tmp/.  If you have a
> mind to, you can replace that subdirectory with a symlink to a (suitably
> secure) directory elsewhere.
>

-- Vlad

pgsql-general by date:

Previous
From: Markus Schiltknecht
Date:
Subject: Re: Large Object to Bytea Conversion
Next
From: Marc Evans
Date:
Subject: Re: creating functions with variable argument lists