Re: Query performance

From: "Jeroen T(dot) Vermeulen" <jtv(at)xs4all(dot)nl>
To: "Stephen Davies" <sdc(at)sdc(dot)com(dot)au>
Cc: pgsql-interfaces(at)postgresql(dot)org
Subject: Re: Query performance
Date: 2007-08-21 11:39:27
Message-ID: 20140.58.136.19.146.1187696367.squirrel@webmail.xs4all.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-interfaces by date

  From Date Subject
Next Message Rob 2007-08-21 20:03:21 PQexecParams and wchar_t
Previous Message Stephen Davies 2007-08-18 06:40:28 Query performance