05:35Citus and JSON for real-time analytics at Vizor Games | Citus Con: An Event for Postgres 2023
From the creator
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 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. ► Video bookmarks: ⏩ 00:00 Introducing Ivan ⏩ 00:29 Talk begin ⏩ 02:23 Requirements for analytics @ Vizor Games ⏩ 06:09 Details of real-time analytics solution ⏩ 08:19 Performance Results ⏩ 08:46 Special JSONB considerations ⏩ 15:08 Maintenance: Roles, Tools, & multi-tenancy ⏩ 22:53 User experience: Expectation vs Reality ⏩ 24:54 Monitoring memory usage & q
Published 2023-05-08 · Watch on YouTube ↗
Availability and playback restrictions are controlled by the original channel.





