Re: log_temp_files confusion

W dniu 13 stycznia 2010 19:52 użytkownik Andrej
<andrej(dot)groups(at)gmail(dot)com>napisał:

> 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.
>

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(at)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.

--
Filip Rembiałkowski
JID,mailto:filip(dot)rembialkowski(at)gmail(dot)com
http://filip.rembialkowski.net/