Feb 2019 Demo of Postgres & Citus for Lightning-Fast Analytics Queries
Vložit
- čas přidán 8. 07. 2024
- A demo to learn how you can use Citus to scale out Postgres and provide fast analytics queries. Comparing a 4-node Citus database cluster to a single Postgres node (both in the cloud), this demo will show you how Citus shards Postgres to give you lightning fast performance for analytics, at scale.
-----------------------------------
Video bookmarks:
► 2:10 Why use Postgres and Citus for real-time analytics?
► 6:56 Demo of fast analytics queries with Postgres and Citus
► 18:28 Performance comparisons of Citus vs. single Postgres node
► 19:03 Benefits of using Citus for demanding analytics workflows
► 20:20 How Heap uses a 70-node Citus database cluster
► 22:21 How Microsoft uses Citus for Windows telemetry data and VeniceDB
-----------------------------------
This demo of scaling out Postgres with the Citus extension to Postgres is useful for developers building customer-facing analytics dashboards who need to ingest data in real time while delivering sub-second responses; and for teams looking for a way to consolidate database platforms, to avoid having separate data stores for your transactional (OLTP) and analytics (OLAP) workloads. Citus is also a frequent choice for SaaS companies building multi-tenant B2B applications.
Citus is available as open source, as a fully-managed database as a service, and as enterprise software. The Citus extension to Postgres was created by the team at Citus Data, now part of the Microsoft family.
✅ See how enterprises and SaaS businesses use Citus for real-time analytics today:
www.citusdata.com/customers/
✅ Join the Citus database community’s public slack channel:
slack.citusdata.com/
✅ Star the GitHub repo for the open source Citus database:
github.com/citusdata/citus
✅ Learn more about the Citus distributed database and how Citus scales out Postgres for both multi-tenant SaaS use cases and for real-time analytics workloads:
www.citusdata.com/product
#Postgres #PostgreSQL #CitusData - Věda a technologie