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/ ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
