Re: Query performance - Mailing list pgsql-interfaces

From Jeroen T. Vermeulen
Subject Re: Query performance
Date
Msg-id 20140.58.136.19.146.1187696367.squirrel@webmail.xs4all.nl
Whole thread Raw
In response to Query performance  (Stephen Davies <sdc@sdc.com.au>)
List pgsql-interfaces
On Sat, August 18, 2007 13:40, Stephen Davies wrote:

> select count(rdate),rdate from reading where sensor_id in
> (1137,1138,1139) group by rdate order by rdate desc limit 1;
>
> takes a few seconds but:

Interesting!  However this is probably not the best list to ask, since
it's about the backend and quite independent of any interface.  You may
have more luck on pgsql-general.


Jeroen




pgsql-interfaces by date:

Previous
From: Stephen Davies
Date:
Subject: Query performance
Next
From: Rob
Date:
Subject: PQexecParams and wchar_t