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