Re: Temp file space (Re: creating an index with tablespace on a dedicated filesystem) - Mailing list pgsql-general

From Tom Lane
Subject Re: Temp file space (Re: creating an index with tablespace on a dedicated filesystem)
Date
Msg-id 29085.1166137314@sss.pgh.pa.us
Whole thread Raw
In response to Re: Temp file space (Re: creating an index with tablespace on a dedicated filesystem)  (Vlad <marchenko@gmail.com>)
List pgsql-general
Vlad <marchenko@gmail.com> writes:
> which means that earlier suggestion you've made - to host temp dir on
> a separate hd linked to temp dir under data tree it's not quite a
> straight solution .... I assume that link will be erased by postgres
> every time it finishes operating with temp directory.

No, it just deletes the contents of the directory, it has no occasion to
destroy a symlink.

It is true that you'd have to set the symlink up manually any time you
created a database, but after that it should be a non-issue.

            regards, tom lane

pgsql-general by date:

Previous
From: Richard Broersma Jr
Date:
Subject: Re: A few SQL questions
Next
From: Ben
Date:
Subject: Re: a question for the way-back machine