Temp files on Commit

From: "Nicholson, Brad (Toronto, ON, CA)" <bnicholson(at)hp(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Temp files on Commit
Date: 2013-08-22 15:20:43
Message-ID: EC55DC235432104F8255702A8D7344D94196C1D0@G4W3302.americas.hpqcorp.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Janes 2013-08-22 15:28:10 Re: PostgreSQL 9.2 Logging
Previous Message Adrian Klaver 2013-08-22 13:34:59 Re: How to know detailed information about HOT(Heap-Only Tuples)?