Postgres Pro
Downloads
Home   >   mailing lists

Where are the temporary work / sort files please - Mailing list pgsql-admin

From adey
Subject Where are the temporary work / sort files please
Date
Msg-id 1c66bda80607122114w2b981f22p44a1ad2ab6fa0e32@mail.gmail.com
Whole thread Raw
Responses Re: Where are the temporary work / sort files please  (Andy Shellam <andy@andycc.net>)
List pgsql-admin
Tree view
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?
 

pgsql-admin by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: PG slowdown
Next
From: "Benjamin Krajmalnik"
Date:
Subject: Identifying object from file on disk