Re: [PERFORM] General DB Tuning

2005-07-12 Thread Brent Henry
We are running Postgres 8.0.2 with the 8.0.2 jdbc driver. And yes we are using prepared statements. I've spent hours trying to get the 'log_min_duration_statement' and 'log_duration' options to work with no luck. I never get any duration from the statement. I also never see 'begin' or 'commit'

Re: [PERFORM] General DB Tuning

2005-07-12 Thread Brent Henry
ent > to the duration using > the process ID or session ID. The default is off. > Only superusers can > change this setting. > > Brent Henry wrote: > > Help! After recently migrating to Postgres 8, > I've > > discovered to my horror that I can't determine > wh

[PERFORM] General DB Tuning

2005-07-12 Thread Brent Henry
Help! After recently migrating to Postgres 8, I've discovered to my horror that I can't determine which queries are poorly performing anymore because the logging has drastically changed and no longer shows durations for anything done through JDBC. So I'm desperately trying to do performance tunin