Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Query performance
- From: "Jeroen T. 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: Tue, 21 Aug 2007 18:39:27 +0700 (ICT)
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
- References:
- Query performance
- From: Stephen Davies
- Query performance
- Prev by Date: Query performance
- Next by Date: PQexecParams and wchar_t
- Previous by thread: Query performance
- Next by thread: PQexecParams and wchar_t
- Indexes: