I’m pleased to present an abbreviated version of the tutorial we presented at PGConf Silicon Valley on "Real-Time Analytics in PostgreSQL“. Please join me on Wednesday, December 9th at 10 am PST for a webinar in which I will demonstrate how to perform fast analytical queries on real-time data in PostgreSQL.
During this live webinar, we will show how to use PostgreSQL as the backend of a real-time analytics dashboard for a continuous stream of events from the Github archive. We will discuss several approaches and will demonstrate how to make PostgreSQL perform well on both the ingestion side and the querying side even for very large datasets by combining cached aggregates with a queue of recent changes.
A typical approach to real-time analytics can involve storing events data in HDFS, compute aggregates using Spark, and putting the results into Cassandra to let applications access them. By the end of this webinar, users who need real-time insight into data using a dashboard, which often involves a number of scalability problems, will learn that PostgreSQL can perform all of these tasks efficiently.
I hope you can attend my live webinar. If not and this topic interests you, please register anyway and we’ll send you a link to the video recording of the webinar shortly after the session concludes.