Re: Relation between pgsql_tmp and work_mem

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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073