Re: [GENERAL] How to log query parameters instead of variables with log_min_duration_statement

2010-06-28 Thread Max Williams
I'm running 8.4.4 so you are saying this should work? I don't really want to go to debug level logging, tried it for 5 mins and it just logs too much! Max -Original Message- From: Tom Lane [mailto:t...@sss.pgh.pa.us] Sent: 28 June 2010 15:28 To: Max Williams Cc: pgs

[GENERAL] How to log query parameters instead of variables with log_min_duration_statement

2010-06-28 Thread Max Williams
:21:49 dbs1 postgres[20866]: [2-2]FROM "XYZ123" AS "T0" Jun 28 10:21:49 dbs1 postgres[20866]: [2-3]WHERE ("T0"."Id" = $1) I'd like to log or find out what $1 was from the postgresql server side, not the application side. Is this possible? Best Regards, Max Williams

Re: [GENERAL] Performance drop after upgrading to 8.4.4?

2010-06-07 Thread Max Williams
No one has had this problem??? Should I perhaps direct this to the developers list? Cheers, Max From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Max Williams Sent: 03 June 2010 14:22 To: pgsql-general@postgresql.org Subject: [GENERAL] Performance

[GENERAL] Performance drop after upgrading to 8.4.4?

2010-06-03 Thread Max Williams
Hi, I was doing some benchmarking while changing configuration options to try to get more performance out of our postgresql servers and noticed that when running pgbench against 8.4.3 vs 8.4.4 on identical hardware and configuration there is a large difference in performance. I know tuning is a