Re: creating an index with tablespace on a dedicated filesystem (postgresql 8.1.5)

From: Vlad <marchenko(at)gmail(dot)com>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: creating an index with tablespace on a dedicated filesystem (postgresql 8.1.5)
Date: 2006-12-14 14:48:08
Message-ID: cd70c6810612140648y63f091c2y3ec12386fb7d8759@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Marc Evans 2006-12-14 15:17:49 Re: creating functions with variable argument lists
Previous Message William Leite Araújo 2006-12-14 13:58:55 Re: A VIEW mimicing a TABLE