Обсуждение: Where are the temporary work / sort files please

Поиск
Список
Период
Сортировка

Where are the temporary work / sort files please

От
adey
Дата:
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?
 

Re: Where are the temporary work / sort files please

От
Andy Shellam
Дата:
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!


Re: Where are the temporary work / sort files please

От
Chris Browne
Дата:
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