David Rees [drees76@xxxxxxxxx] wrote:
Along those lines, couldn't you just have the DB do the work?
select max(ts_id), min(ts_id) from ... where ts_interval_start_time >=
... and ...
Then you don't have to transfer 500k ids across the network...
I guess you didn't read the entire thread: I started it because the
query you suggest took 15 mins to complete.
Brian
--
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
