From: Mark Hamby [mailto:[EMAIL PROTECTED]]
>
> Marc,
> Did you ever get your problem solved to your satisfaction?
> We have a very simular problem with a historical database
> containing typically 5K id and updates to data every few
> seconds. We tried unsuccessfully to optimize queries
> such as those already suggested to you. We found the best
> means to quickly query the data valid at any given time was
> to:
[snip]
By adding an index, I was able to get the performance of the
query within a reasonable threshold; it's still slow, but
acceptable. I'll bear your suggestion in mind for next time
I run into this kind of problem, though, if my sol'n can't
handle the data. Thanks,
- Marc
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://www.postgresql.org/search.mpl
