DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=Message-ID:Received:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding;
	b=dlYn9uGbeNqkmptWPFwWrLks7RsgJNmSD1q5hMJaAa9dAPjqDOQUsuN4ftlFEkYMdYBqBHo1Qo5TSjAX5rdC1xkfm7deTdKCFT228Qn12Zt6zkziSUf0MgSpLdU/O07AAr695Evu0+Lo5uGlSehu5GTWoN3i35nQXgG8BM4/M4Y=
	;
Message-ID: <20050713013630.18625.qmail@web33911.mail.mud.yahoo.com>
Date: Tue, 12 Jul 2005 18:36:30 -0700 (PDT)
From: Brent Henry <bh_pgperf@yahoo.com>
Subject: Re: General DB Tuning
To: Christopher Kings-Lynne <chriskl@familyhealth.com.au>,
	Dennis <dennis@works4me.com>, Tom Arthurs <tarthurs@jobflash.com>
Cc: pgsql-performance@postgresql.org
In-Reply-To: <42D46BC4.2010907@familyhealth.com.au>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

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' in the log so I can't tell how long my
batch commands are taking to commit to the DB.

Is there a different kind of 'prepared' statements
that we should be using in the driver to get logging
to work properly?  What is the 'new' protocol?

Tom, what version are you using?  Are you using
prepared statements in JDBC?

-Brent


--- Christopher Kings-Lynne
<chriskl@familyhealth.com.au> wrote:

> >> 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
> 
> 
> ---------------------------(end of
> broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
> 
>                http://www.postgresql.org/docs/faq
> 


____________________________________________________
Start your day with Yahoo! - make it your home page
http://www.yahoo.com/r/hs