Skip site navigation (1) Skip section navigation (2)

Re: Temp files on Commit

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Nicholson, Brad (Toronto, ON, CA)" <bnicholson(at)hp(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Temp files on Commit
Date: 2013-08-22 15:40:27
Message-ID: 13893.1377186027@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-general
"Nicholson, Brad (Toronto, ON, CA)" <bnicholson(at)hp(dot)com> writes:
> 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.

They're not being written on commit, they're being cleaned up.  That
message about tempfile usage isn't written until the file is deleted,
since we don't know its maximum size for sure until then.

There is some setting that controls whether such messages appear at
all, but I'm too lazy to go look it up right now.

			regards, tom lane


In response to

Responses

pgsql-general by date

Next:From: bricklenDate: 2013-08-22 15:44:42
Subject: Re: Temp files on Commit
Previous:From: Don ParrisDate: 2013-08-22 15:29:56
Subject: Re: Locale Issue

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group