Relation between pgsql_tmp and work_mem
I read somewhere in the archives we can set work_mem
to the largest size of tmp file created in the
pgsql_tmp folder....
but how can i make those files in pgsql_tmp not be
deleted after use... so that i can get the file
listing for all files created during the run...
currently i am doing "ls -l " sampling at 1s.... is
there a better way....
Himanshu
__________________________________
Do you Yahoo!?
Yahoo! Small Business - Try our new resources site!
http://smallbusiness.yahoo.com/resources/
Import Notes
Reply to msg id not found: 6667
Himanshu Baweja wrote:
I read somewhere in the archives we can set work_mem
to the largest size of tmp file created in the
pgsql_tmp folder....
but how can i make those files in pgsql_tmp not be
deleted after use... so that i can get the file
listing for all files created during the run...
currently i am doing "ls -l " sampling at 1s.... is
there a better way....
Our TODO has:
* All ability to monitor the use of temporary sort files
so we know we need to give users that ability someday.
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073