Скачать с ютуб Scaling Postgres for Time Series Data with the Citus Database в хорошем качестве

Scaling Postgres for Time Series Data with the Citus Database

A technical interview (and a demo) to learn how you can use the PostgreSQL database—with the Citus and pg_partman extensions—to scale out Postgres and analyze massive volumes of time series data. Together, Postgres + Citus + pg_partman are a powerful, distributed time series database. ----------------------------------- Video bookmarks: ► 7:53 What is driving the interest in time series data? ► 10:06 What are challenges for databases when it comes to handling time series data? ►14:39 What makes Postgres a good choice for analyzing time series data? ►26:30 Marco’s live demo of how you can partition and shard Postgres with pg_partman and Citus to scale out Postgres and analyze massive amounts of time series data. ----------------------------------- If you are working with time series data today, you are probably dealing with large data volumes—and you might not be able to control the amount of data people are sending you. So you need a database that can scale out horizontally to give you performance—and yet, you also need a database that can do fairly advanced analytics so you and your users can find and discover the patterns in time series data. (think: joins, rollups, aggregates, complex queries across hundreds of millions or billions of rows) Citus is an extension to Postgres that transforms Postgres into a distributed database. Available as a database as a service, as enterprise software, and as open source, Citus is popular with developers building multi-tenant SaaS applications and with teams building real-time analytics dashboards that require sub-second responses—including analytic dashboards dealing with time series data. ✅ See how enterprises and SaaS businesses use Citus to scale out Postgres today: https://www.citusdata.com/customers/ ✅ Join the Citus database community’s public slack channel: https://slack.citusdata.com/ ✅ Star the GitHub repo for the open source Citus database: https://github.com/citusdata/citus ✅ Learn more about the Citus distributed database and how Citus scales out Postgres for time series data. Citus is available as open source, as enterprise software you can run anywhere, and as a fully-managed database as a service: https://www.citusdata.com/product