Where are the temporary work / sort files please
От
adey
Тема
Where are the temporary work / sort files please
Дата
Msg-id
1c66bda80607122114w2b981f22p44a1ad2ab6fa0e32@mail.gmail.com
Список
Дерево обсуждения
Re: Where are the temporary work / sort files please Chris Browne <cbbrowne@acm.org>
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?
В списке pgsql-admin по дате отправления
