Timeseries with PostgreSQL - eviltoast
How to use set-returning functions in PostgreSQL to generate simple timeseries data.

A relatively simple but common application of time series done with PG.