Re: Slow query after upgrades

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