Sign in to confirm you’re not a bot
This helps protect our community. Learn more

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

Microsoft Developer
588K subscribers
<__slot-el>
<__slot-el>
440 views 1 year ago #PostgreSQL #CitusCon #Citus
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 experienc …...more
...more
Citus and JSON for real-time analytics at Vizor Games | Citus Con: An Event for Postgres 2023
6Likes
440Views
2023May 8
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 & query execution ⏩ 28:35 Q&A ✅ Learn more: Watch more Citus Con talks: https://aka.ms/cituscon-playlist 📕 Everything you need to know about Citus Con: An Event for Postgres can be found at: https://aka.ms/cituscon 📌 Let’s connect:   Twitter – @CitusCon,   / cituscon   ⭐ Stay connected with the Citus open source project on GitHub: https://github.com/citusdata/citus More resources: 📣 Slides for this talk: https://speakerdeck.com/ivyazmitinov/... #CitusCon #PostgreSQL #Citus

Follow along using the transcript.

Microsoft Developer

588K subscribers