Re: Relation between pgsql_tmp and work_mem - Mailing list pgsql-general

From Bruce Momjian
Subject Re: Relation between pgsql_tmp and work_mem
Date
Msg-id 200505162310.j4GNAwn19876@candle.pha.pa.us
Whole thread Raw
In response to Relation between pgsql_tmp and work_mem  (Himanshu Baweja <himanshubaweja@yahoo.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Distinguishing between connections in pg_hba.conf
Next
From: MLikharev@micropat.com
Date:
Subject: CREATE TEMP TABLE AS SELECT/ GET DIAGNOSTICS ROW_COUNT