Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Thu, 13 Jul 2006 16:14:50 +1200
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."
(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?
- Follow-Ups:
- Re: Where are the temporary work / sort files please
- From: Chris Browne
- Re: Where are the temporary work / sort files please
- From: Andy Shellam
- Re: Where are the temporary work / sort files please
- Prev by Date: Re: PG slowdown
- Next by Date: Identifying object from file on disk
- Previous by thread: unsubscribe pgsql-admin
- Next by thread: Re: Where are the temporary work / sort files please
- Indexes: