Re: Storage location of temporary files

From: Christian Schröder <cs(at)deriva(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Storage location of temporary files
Date: 2008-10-31 08:13:17
Message-ID: 490ABE1D.3060700@deriva.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Christian Schröder 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?
Just one addition: I have found the following in the 8.3 docs:

temp_tablespaces (string)
This variable specifies tablespace(s) in which to create temporary
objects (temp tables and indexes on temp tables) when a CREATE
command does not explicitly specify a tablespace. Temporary files
for purposes such as sorting large data sets are also created in
these tablespace(s).

So my problem seems to have been addressed in the 8.3 release. Maybe we
can upgrade our database, but until that happens I will need another
solution, so my question remains ...

Regards,
Christian

--
Deriva GmbH Tel.: +49 551 489500-42
Financial IT and Consulting Fax: +49 551 489500-91
Hans-Böckler-Straße 2 http://www.deriva.de
D-37079 Göttingen

Deriva CA Certificate: http://www.deriva.de/deriva-ca.cer

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Magnus Hagander 2008-10-31 08:22:08 Re: Decreasing WAL size effects
Previous Message Christian Schröder 2008-10-31 08:01:29 Storage location of temporary files