Thread: Where are the temporary work / sort files please
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?
These do exist as the documentation says - I found them in my 8.1.3 install, but only for a couple of databases. Perhaps they're only used when there has a need to be swapping data to disk? adey wrote: > 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? > > !DSPAM:14,44b5cb6f34532045524622!
adey11@gmail.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