Home > mailing lists

Temp files on Commit - Mailing list pgsql-general

From	Nicholson, Brad (Toronto, ON, CA)
Subject	Temp files on Commit
Date	August 22, 2013 18:21:34
Msg-id	EC55DC235432104F8255702A8D7344D94196C1D0@G4W3302.americas.hpqcorp.net Whole thread Raw
Responses	Re: Temp files on Commit (Tom Lane <tgl@sss.pgh.pa.us>)
List	pgsql-general

Hi,

I’m seeing cases where I have temp files being written on commit, such as.

2013-08-16 12:09:02 GMT [14480]: [588-1] user=dbuser,db=dbname STATEMENT: COMMIT

2013-08-16 12:09:02 GMT [14480]: [589-1] user= dbuser,db=dbname LOG: temporary file: path "base/pgsql_tmp/pgsql_tmp14480.263", size 814822

Is this a case of having work_mem set to low, or something else? I haven’t seen temp files on commit before.

Thanks,

Brad.

From: Adrian Klaver
Date: 22 August 2013, 16:35:11
Subject: Re: How to know detailed information about HOT(Heap-Only Tuples)?

From: Jeff Janes
Date: 22 August 2013, 18:28:19
Subject: Re: PostgreSQL 9.2 Logging