Herrera wrote:
> I don't think you showed us the EXPLAIN ANALYZE results that Scott
> requested.
--
This email is for the person(s) identified above, and is confidential to
the sender and the person(s). No one else is authorised to use or
disseminate this email
sor_id) REFERENCES sensor(id)
Cheers,
Stephen
On Wednesday 22 August 2007 20:28, Russell Smith wrote:
> Stephen Davies wrote:
> > I have a PostgreSQL 8.2.4 table with some seven million rows.
> >
> > The psql query:
> >
> > select count(rdate),rdate from reading
ted faster than =a or =b or =c. Am I wrong for PostgreSQL?
Stephen
On Wednesday 22 August 2007 22:55, Michael Glaesemann wrote:
> On Aug 22, 2007, at 5:58 , Russell Smith wrote:
> > Stephen Davies wrote:
> >> select count(rdate),rdate from reading where sensor_id in
> >>
1138,1139}'::integer[]))
-> Bitmap Index Scan on reading_sensor
(cost=0.00..528.37 rows=28650 width=0)
Index Cond: (sensor_id = ANY
('{1137,1138,1139}'::integer[]))
(8 rows)
TIA,
Stephen Davies
--
=
