From: Brent Henry <bh_pgperf@yahoo.com>
To: Christopher Kings-Lynne <chriskl@familyhealth.com.au>
To: Dennis <dennis@works4me.com>
To: Tom Arthurs <tarthurs@jobflash.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: General DB Tuning
Date: Tue, 12 Jul 2005 18:36:30 -0700 (PDT)
Message-ID: <20050713013630.18625.qmail@web33911.mail.mud.yahoo.com> (raw)
In-Reply-To: <42D46BC4.2010907@familyhealth.com.au>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: bh_pgperf@yahoo.com, chriskl@familyhealth.com.au, dennis@works4me.com, tarthurs@jobflash.com
Subject: Re: General DB Tuning
In-Reply-To: <20050713013630.18625.qmail@web33911.mail.mud.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox