Re: log_temp_files confusion

From: Andrej <andrej(dot)groups(at)gmail(dot)com>
To: Filip Rembiałkowski <plk(dot)zuber(at)gmail(dot)com>
Cc: PG-General Mailing List <pgsql-general(at)postgresql(dot)org>
Subject: Re: log_temp_files confusion
Date: 2010-01-13 18:52:14
Message-ID: b35603931001131052t7a5863d6j3da570deb90ac13d@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

2010/1/14 Filip Rembiałkowski <plk(dot)zuber(at)gmail(dot)com>:
> I would like to log usage of temporary files for sort/join operations, but
> only when size of these files exceeds some threshold.
>
> So I set in postgresql.conf (this is 8.4.2)
> log_temp_files = 4MB
Just a wild guess... the DOCU says it's an integer, not an INT & STRING.

Try
log_temp_files = 4194304

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2010-01-13 19:00:59 PgEast CFP (second call)
Previous Message Alex - 2010-01-13 18:20:55 pl/perl setof function