[PERFORM] "COPY TO stdout" statements occurrence in log files

2011-01-14 Thread Fernando Mertins
Hi there, I have one log file per week and logging all statements >= 500 ms execution time. But, with "normal" statements are occuring something like this: 2011-01-13 00:11:38 BRT LOG: duration: 2469.000 ms statement: FETCH 1000 IN bloboid 2011-01-13 00:12:01 BRT LOG: duration: 797.000 ms stat

[PERFORM] Same stament sometime fast, something slow

2011-01-04 Thread Fernando Mertins
Hi there, this is my first post. I have a PostgreSQL 8.3.6, compiled by Visual C++ build 1400 running on Windows with virtual machine, 2 GB ram, and configured the postgresql.conf file to log statements duration >= 500 ms. And I have this query/log entry: 2011-01-03 23:06:29 BRT LOG: duration: 2