Re: temp space on different location

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Mario Weilguni <mweilguni(at)sime(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: temp space on different location
Date: 2002-04-24 22:08:43
Message-ID: 19279.1019686123@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Mario Weilguni <mweilguni(at)sime(dot)com> writes:
> Is it possible to instruct postgres to use temporary space on a different
> location in the filesystem?

In 7.2, temp files are made in $PGDATA/base/dboid/pgsql_tmp/. You could
replace the pgsql_tmp subdirectory(s) with a symlink to some other
directory.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2002-04-24 22:21:31 Re: No long-lived transaction, still can't delete tuples
Previous Message Stephan Szabo 2002-04-24 21:53:24 Re: Why is outer Join way quicker?