Re: [GENERAL] log_temp_files confusion

2010-01-13 Thread Filip Rembiałkowski
W dniu 13 stycznia 2010 19:52 użytkownik Andrej napisał: > 2010/1/14 Filip Rembiałkowski : > > 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_fil

Re: [GENERAL] log_temp_files confusion

2010-01-13 Thread Andrej
2010/1/14 Filip Rembiałkowski : > 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

[GENERAL] log_temp_files confusion

2010-01-13 Thread Filip Rembiałkowski
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 But then I got these messages in log file 2010-01-12 13:24:49 CET 24899 fi...@la_filip LOG: temporary