Real-Time Analytics in PostgreSQL Webinar

Marco Slot Dec 7, 2015

About Citus

Citus is a distributed database that scales out PostgreSQL. An extension to Postgres, Citus is available as open source, as on-prem software, and as a fully-managed database as a service.

Sign up for our newsletter

Enjoy what you're reading? Sign-up to our newsletter to stay informed:

Other Recent Posts

Migrating from single-node Postgres to Citus How Citus works (a look at dynamic executors) Citus 7: Transactions, Framework Integration, and Postgres 10 More Articles

Like our blog, or have a question about Citus? Join us on Slack for a chat :)

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.

Watch recording here

← Next article Previous article →