Re: General DB Tuning

From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
To: Dennis <dennis(at)works4me(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: General DB Tuning
Date: 2005-07-13 01:17:56
Message-ID: 42D46BC4.2010907@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

>> we are using jdbc -- the "log_min_duration_statement = 3000 "
>> statement works fine for me. Looks like there's no other work around
>> for the bug(?). Not sure since I have no interest in logging a
>> million statements a day, I only want to see the poorly performing hits.
>
> Doesn't it depend on what jdbc driver you are using?

It depends if he's using new-protocol prepared queries which don't get
logged properly. Wasn't that fixed for 8.1 or something?

Chris

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Arthurs 2005-07-13 01:30:14 Re: General DB Tuning
Previous Message Dennis 2005-07-13 01:05:13 Re: General DB Tuning