[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: [GENERAL] Storage location of temporary files
From:       Aaron <aaron () chasingnuts ! com>
Date:       2008-10-31 14:31:30
Message-ID: 13e03a2b0810310731wd0c8d3boa1bdd90bf81bc1f2 () mail ! gmail ! com
[Download RAW message or body]

I too have used a symlink for some time (years) to put temp onto
dedicated disks without any problems.  I am not sure if 8.3 is
different but I symlink the directory: base/pgsql_tmp


Aaron Thul
http://www.chasingnuts.com



On Fri, Oct 31, 2008 at 8:11 AM, Sam Mason <sam@samason.me.uk> wrote:
> On Fri, Oct 31, 2008 at 09:01:29AM +0100, Christian Schrrrder wrote:
>> So I would like
>> to use a faster disk for these temporary files, too, but I could not
>> find where the temporary files are located. Is there a separate
>> directory? I have found a "pgsql_tmp" directory inside of the database
>> directories ("base/<oid>/pgsql_tmp"). Is this what I'm looking for?
>
> Yes, I believe it's accepted practice to replace this directory with a
> symlink.  I've done this before and it's behaved as I'd expect.
>
>
>  Sam
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
[prev in list] [next in list] [prev in thread] [next in thread]