Using Postgres and Citus for Lightning Fast Analytics Queries

Sdílet
Vložit
  • čas přidán 6. 12. 2018
  • 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
  • Věda a technologie

Komentáře • 1

  • @RamveerSingh
    @RamveerSingh Před 5 lety

    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