Querying Time Series in PostgreSQL

Apologies for the self-plug, but you can have a play around with some of PG&#x27;s date&#x2F;time functionality by going to <a href="http://pgexercises.com/questions/date/" rel="nofollow">http:&#x2F;&#x2F;pgexercises.com&#x2F;questions&#x2F;date&#x2F;</a>

Really interesting read. Anyone got any comparison between the performance of these against say pandas or R[1]? I&#x27;d be particularly interested if anyone has stored multiple timeseries in a table and the performance of looking for individual or the latest timeseries.<p>[1]: I haven&#x27;t used R myself.

This is pretty cool, I didn&#x27;t know about window functions in Postgres. Most of the time when dealing with time series data I end up dropping into Python (pandas) or R (xts package), but it is nice to see how to do a lot of analysis right in the database.

Heh, some of the queries we do at work are pretty much exactly like the ones in the examples. Postgres is cool.