Postgres Pro
Downloads
Home   >   mailing lists

Re: log_temp_files confusion - Mailing list pgsql-general

From Andrej
Subject Re: log_temp_files confusion
Date
Msg-id b35603931001131052t7a5863d6j3da570deb90ac13d@mail.gmail.com
Whole thread Raw
In response to log_temp_files confusion  (Filip Rembiałkowski <plk.zuber@gmail.com>)
Responses Re: log_temp_files confusion  (Filip Rembiałkowski <plk.zuber@gmail.com>)
List pgsql-general
Tree view 
2010/1/14 Filip Rembiałkowski <plk.zuber@gmail.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

pgsql-general by date:

Previous
From: Amy Smith
Date:
Subject: postgres
Next
From: "Joshua D. Drake"
Date:
Subject: PgEast CFP (second call)