Re: Querying sporadic time series type data.

The convention here is to inline or bottom-post.

On Saturday, October 3, 2020, Tim Uckun <timuckun(at)gmail(dot)com> wrote:

> Given the scale I am working at I thought a specific time scale
> database would be overkill but I'll look into it nevertheless. Even
> if I do write the queries with the known metrics I am still trying to
> figure out how to efficiently query "last known value of this metric
> on or before X time" without a correlated subquery which would be a
> massively inefficient query.
>

Yes, if the time is arbitrary you are stuck with a where clause,
sort-and-limit. DISTINCT ON can be useful for returning multiple entities
over the same metric.

Indexes, possibly partial (if you don’t normalize the model), should help.

Even massively inefficient can be efficient enough...

David J.