pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: alvin.yk@gmail.com
To: Kris Jurka <books@ejurka.com>
Cc: pgsql-jdbc@postgresql.org
Cc: pgsql-performance@postgresql.org
Subject: Re: 8.0.1 performance question.
Date: Tue, 5 Apr 2005 00:44:26 +0800
Message-ID: <d7c78ba105040409444ceacdcc@mail.gmail.com> (raw)
In-Reply-To: <Pine.BSO.4.56.0504041109140.4842@leary.csoft.net>
References: <d7c78ba105040403327d66fff4@mail.gmail.com>
	<26421.1112629761@sss.pgh.pa.us>
	<d7c78ba1050404090049fac5ec@mail.gmail.com>
	<Pine.BSO.4.56.0504041109140.4842@leary.csoft.net>

Thank you for the quick response.  To help me debug what's happening,
can you tell me what's the difference between the 7.4 and 8.0 jdbc
drivers in this regard?  Is this something that is newly introduced in
8.0?  Or is this something that has always been happening?

Thanks.



On Apr 5, 2005 12:15 AM, Kris Jurka <books@ejurka.com> wrote:
> 
> 
> On Tue, 5 Apr 2005 alvin.yk@gmail.com wrote:
> 
> > I see statements below being executed non-stop.  Who is triggering these
> > statemetns?  Is this normal?  What am I doing wrong?
> >
> >
> > 2005-04-04 18:05:00 CST PARSELOG:  statement: SELECT attnotnull FROM
> > pg_catalog.pg_attribute WHERE attrelid = $1 AND attnum = $2
> > 2005-04-04 18:05:00 CST PARSELOG:  statement: SELECT def.adsrc FROM
> > pg_catalog.pg_class c JOIN pg_catalog.pg_attribute a ON
> > (a.attrelid=c.oid
> > ) LEFT JOIN pg_catalog.pg_attrdef def ON (a.attrelid=def.adrelid AND
> > a.attnum = def.adnum) WHERE c.oid = $1 and a.attnum = $2 AND def.adsrc
> > L
> > IKE '%nextval(%'
> 
> These are the results of ResultSetMetaData.isNullable() and
> isAutoIncrement(), which your code is apparently calling.  The results of
> these calls are cached on a per ResultSet data.  We have discussed
> caching them at a higher level, but couldn't find a way to know when to
> flush that cache.
> 
> Kris Jurka
>



view thread (6+ messages)  latest in thread

Message-ID: <d7c78ba105040409444ceacdcc@mail.gmail.com>
Permalink:  ../d7c78ba105040409444ceacdcc@mail.gmail.com/
Also on:    postgresql.org/message-id/d7c78ba105040409444ceacdcc@mail.gmail.com

 · 

reply

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: alvin.yk@gmail.com, books@ejurka.com, pgsql-jdbc@postgresql.org
  Subject: Re: 8.0.1 performance question.
  In-Reply-To: <d7c78ba105040409444ceacdcc@mail.gmail.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