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

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 (view raw or flat)
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

pgsql-interfaces by date

Next:From: RobDate: 2007-08-21 20:03:21
Subject: PQexecParams and wchar_t
Previous:From: Stephen DaviesDate: 2007-08-18 06:40:28
Subject: Query performance

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