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

Re: Slow query after upgrades

From: "Guillaume Smet" <guillaume(dot)smet(at)gmail(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 22:52:45
Message-ID: 1d4e0c10712131452l65841793r449eb3c7cffbf3a5@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
On Dec 13, 2007 11:37 PM, Tom Duffey <tduffey(at)techbydesign(dot)com> wrote:
> foo=> EXPLAIN SELECT point_history.point_id, point_history.timestamp,
> point_history.value, point_history.status FROM point_history WHERE
> point_history.point_id = 21001 AND point_history.timestamp >=
> '2007-12-11 22:22:45' ORDER BY point_history.timestamp DESC;
>                                                   QUERY PLAN
> ------------------------------------------------------------------------------------------------------------
>   Index Scan Backward using point_history_pkey on point_history
> (cost=0.00..264.60 rows=58 width=20)
>     Index Cond: ((point_id = 21001) AND ("timestamp" >= '2007-12-11
> 22:22:45'::timestamp without time zone))
> (2 rows)

It's not an EXPLAIN ANALYZE so we can't see if the query is slow or fast.

If it's fast using the parameters in psql, just try to add
protocolVersion=2 to your JDBC connection URL as I told you earlier.
It should solve your problem. You won't be able to use new features of
protocol v3 but if you used 7.4 before, it shouldn't be a problem for
you.

--
Guillaume

In response to

Responses

pgsql-jdbc by date

Next:From: Tom DuffeyDate: 2007-12-13 22:58:32
Subject: Re: Slow query after upgrades
Previous:From: Tom DuffeyDate: 2007-12-13 22:37:29
Subject: Re: Slow query after upgrades

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