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

Re: Slow query after upgrades

From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: Tom Duffey <tduffey(at)techbydesign(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Slow query after upgrades
Date: 2007-12-13 23:05:46
Message-ID: 4761BACA.4020008@opencloud.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
Tom Duffey wrote:

> This makes a huge difference, thanks.  However, is there anything I can 
> do to help improve the performance of that query when using a newer 
> protocol?

We need to work out what is going wrong under the newer protocol first, 
which unfortunately can be a bit tricky because psql doesn't use the 
query protocol in the same way as the JDBC driver.

Can you write a little JDBC app that runs the query with EXPLAIN 
ANALYZE, setting parameters in the same way that your real app does, and 
dump out the resultset it gets back? (which should be the EXPLAIN 
results rather than the real data, IIRC)

-O

In response to

Responses

pgsql-jdbc by date

Next:From: Tom DuffeyDate: 2007-12-13 23:27:06
Subject: Re: Slow query after upgrades
Previous:From: Tom DuffeyDate: 2007-12-13 22:58:32
Subject: Re: Slow query after upgrades

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