This is based on an older product called Truviso which was acquired by Cisco in 2012.
Shameless plug, but if you want to try a similar product that you can download and play around with today (continuous queries on streams), you can try Striim:
Instead of using Postgres for recovery, the streams are backed by Kafka. You can plug it into your existing streaming infrastructure if you use Kafka today or just deploy Striim standalone.
Disclaimer: I worked at Truviso; I know the PipelineDB guys but I'm not affiliated with the company.