Обсуждение: 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/

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