Using Postgres and Citus for Lightning Fast Analytics Queries

Ғылым және технология

A demo to learn how you can use the Citus database to scale out Postgres and provide fast analytics queries. Using a 4-node Citus Cloud database cluster, this demo will show you how Citus shards Postgres to give you lightning fast performance, at scale.
-----------------------------------
Video bookmarks:
► 3:04 Why use Postgres and Citus for real-time analytics?
► 8:11 Demo of fast analytics queries with Postgres and Citus
► 23:40 Benefits of using Citus for demanding analytics workflows
► 25:24 How Heap Analytics uses the Citus database
► 26:29 How Microsoft uses Citus for their Windows telemetry data and VeniceDB
► 28:02 How Freshworks uses Citus for real-time chat analytics
-----------------------------------
This demo of scaling out Postgres with the Citus extension to Postgres is useful for teams 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 stores for your transactional and analytics workloads.
Citus is available as a database as a service, as enterprise software, and as open source.
✅ 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 real-time analytics dashboards:
www.citusdata.com/product

Пікірлер: 1

  • @RamveerSingh
    @RamveerSingh5 жыл бұрын

    I guess the fair comparison will be to compare citus with postgresql cluster of same no of nodes. Which is now just one node of postgresql and 4 nodes of citus database. Do you have a video on that as well. Also please make a video on scaling multi tenant postgresql instances using citus. Thanks

Келесі