pg.ddx.io pgsql-performance@postgresql.org mailing list archivehelp / color / mirror / Atom feed
From: Kris Jurka <books@ejurka.com>
To: alvin.yk@gmail.com
Cc: pgsql-jdbc@postgresql.org
Cc: pgsql-performance@postgresql.org
Subject: Re: 8.0.1 performance question.
Date: Mon, 4 Apr 2005 11:15:40 -0500 (EST)
Message-ID: <Pine.BSO.4.56.0504041109140.4842@leary.csoft.net> (raw)
In-Reply-To: <d7c78ba1050404090049fac5ec@mail.gmail.com>
References: <d7c78ba105040403327d66fff4@mail.gmail.com>
<26421.1112629761@sss.pgh.pa.us>
<d7c78ba1050404090049fac5ec@mail.gmail.com>
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: <Pine.BSO.4.56.0504041109140.4842@leary.csoft.net> Permalink: ../Pine.BSO.4.56.0504041109140.4842@leary.csoft.net/ Also on: postgresql.org/message-id/Pine.BSO.4.56.0504041109140.4842@leary.csoft.net ·
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 from your mail client; the link fills in the headers below: reply via email Some clients, webmail especially, drop In-Reply-To and References from a link, and the reply then starts a new thread: use the mbox below. To: pgsql-performance@postgresql.org Cc: books@ejurka.com, alvin.yk@gmail.com, pgsql-jdbc@postgresql.org Subject: Re: 8.0.1 performance question. 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> * 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