Episode

Citus and JSON for real-time analytics at Vizor Games | Citus Con: An Event for Postgres 2023

with Ivan Vyazmitinov

CitusCon: An Event for Postgres 2023

Video of a talk by Ivan Vyazmitinov of Vizor Games about their implementation of the Citus open source extension to Postgres, presented at Citus Con: An Event for Postgres 2023. The team at Vizor Games relies completely on the Citus extension to Postgres, since Citus combines the widely-adopted, feature-rich, and mature PostgreSQL database with the promise of infinite scale.

Ivan’s talk includes:

  • How Vizor Games deploys the Citus database cluster on bare metal servers with Gentoo and Btrfs
  • Implementation of ETL with big amount of raw data (about 100GB per day)
  • Building analytics on semi-structured JSONB data and creation of analytical layer of views over it.
  • Administering Citus on 20+ databases within one cluster
  • Interaction with direct cluster users, including analytics and data scientists
  • Integration with BI tools, like Tableau and Metabase

Ivan Vyazmitinov is an and an accidental DBA and Java developer with 5+ years of experience. Starting from 2018 in Vizor Games, he gradually accepted the role of tech lead and gained experience with Citus during the development of an internal analytics system.

Connect

  • Citus Con An Event for Postgres | Twitter: @CitusCon