Re: Where are the temporary work / sort files please

From: Chris Browne <cbbrowne(at)acm(dot)org>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Where are the temporary work / sort files please
Date: 2006-07-13 15:34:43
Message-ID: 60d5c9r018.fsf@dba2.int.libertyrms.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

adey11(at)gmail(dot)com (adey) writes:
> ...but I can't find pgsql_tmp in my v8.1.4 installation.
>
> Where can I find these temp files please?

They get created on demand, and go away when that demand disappears.

Run a big REINDEX and you'll see them pop into place...
--
output = ("cbbrowne" "@" "ntlug.org")
http://cbbrowne.com/info/sap.html
"...Roxanne falls in love with Christian, a chevalier in Cyrano's
regiment who hasn't got the brains God gave an eclair..."
-- reviewer on NPR

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Andy Shellam 2006-07-13 15:50:55 Re: 8.1 Unique Index Issue/Bug???
Previous Message Hyatt, Gordon 2006-07-13 15:22:47 Re: PostgreSQL 8.1.4 install failure on Win XP Home laptop