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!
