> 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.
postgresql.conf.sample has these lines: #log_temp_files = -1 # log temporary files equal or larger # than the specified size in kilobytes; # -1 disables, 0 logs all temp files
I've set it in the config file to log_temp_files = 4096
which shows as
filip@postgres=# show log_temp_files ; log_temp_files ---------------- 4MB (1 row)
Try log_temp_files = 4194304
I will try this, but this would mean that config system is somehow broken.