Depending on your requirements, a single-node solution like PipelineDB may suffice; it's a PostgreSQL extension that lets you write streaming SQL queries.
the esper stuff was on my radar, but something that works with existing postgresql tools is a huge plus.
Doesn't that get in the way of low latency and availability?
[1] http://enterprise.pipelinedb.com/docs/two-phase.html#two-pha...