Skip site navigation (1) Skip section navigation (2)

Re: Picking up strange queries for "pg_catalog"

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Picking up strange queries for "pg_catalog"
Date: 2010-07-04 11:25:07
Message-ID: i0pr2d$211$1@dough.gmane.org (view raw or flat)
Thread:
Lists: pgsql-jdbc
Graham Leggett wrote on 04.07.2010 13:13:
> Hi all,
>
> While investigating some performance issues with a database, I have been
> analysing the database queries, and have discovered that I am getting
> thousands and thousands of queries that look like the ones below.
>
> Asking on the pgsql-general list, I was pointed in the direction of the
> jdbc driver, which in theory is making these queries, but not caching them.
>
> Does this look familiar to anybody?
>
> In addition to this, I am using the atomikos XA transaction manager,
> could this be the source of these queries?
>

I don't think it's the driver "making" these calls. Some of them look like they are a result of calling severl JDBC metadata API functions (e.g DatabaseMetaData.getColumns() or something similar) which in turn are not initiated by the driver, but by the client software. So I would suspect the transaction manager or your ORM library to make those calls (and thus generating the queries)

Thomas


In response to

Responses

pgsql-jdbc by date

Next:From: Craig RingerDate: 2010-07-04 12:52:44
Subject: Re: Unable to commit: transaction marked for rollback
Previous:From: Graham LeggettDate: 2010-07-04 11:13:49
Subject: Picking up strange queries for "pg_catalog"

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group