Re: [GENERAL] Temp file space (Re: creating an index with tablespace on a dedicated filesystem)

2006-12-14 Thread Tom Lane
Vlad <[EMAIL PROTECTED]> 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.

Re: [GENERAL] Temp file space (Re: creating an index with tablespace

2006-12-14 Thread Glen Parker
Vlad wrote: 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. Why would the postmaster

Re: [GENERAL] Temp file space (Re: creating an index with tablespace on a dedicated filesystem)

2006-12-14 Thread Vlad
Tom, 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. Yup, they're only temp files (i

Re: [GENERAL] Temp file space (Re: creating an index with tablespace on a dedicated filesystem)

2006-12-14 Thread Tom Lane
Glen Parker <[EMAIL PROTECTED]> writes: > Tom, is it safe to assume that the contents of the temp directory do not > need to persist across Postgres restarts? Yup, they're only temp files (in fact, I think there is code somewhere that actually runs around and cleans out the temp directories durin