Where are the temporary work / sort files please

From: adey <adey11(at)gmail(dot)com>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>, postgresql-l <postgresql-l(at)Groups(dot)ittoolbox(dot)com>
Subject: Where are the temporary work / sort files please
Date: 2006-07-13 04:14:50
Message-ID: 1c66bda80607122114w2b981f22p44a1ad2ab6fa0e32@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

The postgresql parameter explanation for work_mem say :-

"Another way to set this value is to monitor the Postgres temp files
(in PGDATA/base/DB_OID/pgsql_tmp) and adjust sort_mem
upward if you see a lot of queries swapping from these temp files."

...but I can't find pgsql_tmp in my v8.1.4 installation.
Where can I find these temp files please?

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Benjamin Krajmalnik 2006-07-13 05:27:02 Identifying object from file on disk
Previous Message Joshua D. Drake 2006-07-13 03:50:38 Re: PG slowdown