Re: Storage location of temporary files

From: Sam Mason <sam(at)samason(dot)me(dot)uk>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Storage location of temporary files
Date: 2008-10-31 12:11:52
Message-ID: 20081031121152.GF2459@frubble.xen.chris-lamb.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John DeSoi 2008-10-31 12:19:23 Re: tsearch2 problem
Previous Message Sam Mason 2008-10-31 12:07:08 Re: speed up restore from dump