%3CLINGO-SUB%20id%3D%22lingo-sub-1667562%22%20slang%3D%22en-US%22%3ETalking%20about%20Citus%20%26amp%3B%20Postgres%20at%20any%20scale%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1667562%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EI%20recently%20gave%20a%20talk%20about%20the%20%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fcitusdata%2Fcitus%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3ECitus%20extension%20to%20Postgres%3C%2FA%3E%20at%20the%20Warsaw%20PostgreSQL%20Users%20Group.%20Unfortunately%2C%20I%20did%20not%20get%20to%20go%20in%20person%20to%20beautiful%20Warsaw%2C%20but%20it%20was%20still%20a%20nice%20way%20to%20interact%20with%20the%20global%20Postgres%20community%20and%20talk%20about%20what%20Citus%20is%2C%20how%20it%20works%2C%20and%20what%20it%20can%20do%20for%20you%3C%2FSPAN%3E%3CSPAN%3E.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%3EIf%20you%20are%20already%20familiar%20with%20Po%3C%2FSPAN%3E%3CSPAN%3Estgres%20then%20this%20talk%20should%20be%20a%20good%20introduction%20to%20all%20the%20powerful%20capabilities%20that%20%3CA%20href%3D%22https%3A%2F%2Fwww.citusdata.com%2Fdownload%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3ECitus%3C%2FA%3E%20gives%20you.%20The%20tl%3Bdr%20is%20this%3A%20Citus%20is%20an%20open%20source%20extension%20to%20Postgres%20that%20transforms%20Postgres%20into%20a%20distributed%20database.%20Citus%20uses%20sharding%20and%20replication%20to%20distribute%20your%20data%20and%20your%20Postgres%20queries%20across%20a%20distributed%20database%20cluster.%3CBR%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH2%20id%3D%22toc-hId--1266704013%22%20id%3D%22toc-hId--1266704013%22%3E%3CSPAN%3EShining%20a%20light%20on%20the%20performance%20speedups%20of%20Citus%20(via%20demo)%20%3C%2FSPAN%3E%3C%2FH2%3E%0A%3CP%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%3EEvery%20so%20often%2C%20I%20try%20to%20rethink%20how%20I%20talk%20about%20Citus%20as%20Postgres%20and%20the%20needs%20of%20applications%20evolve%3C%2FSPAN%3E%3CSPAN%3E.%20One%20thing%20we%20have%20not%20done%20very%20much%20is%20talk%20directly%20about%20the%20performance%20improvements%20in%20Citus.%20Sometimes%20it%E2%80%99s%20actually%20slower%2C%20but%20at%20scale%20can%20be%20%3CEM%3Ea%20lot%3C%2FEM%3E%26nbsp%3Bfaster.%20Therefore%2C%20I%20introduced%20every%20Citus%20feature%20with%20some%20benchmarks%20that%20show%20the%20performance%20compared%20to%20a%20(large)%20Postgres%20server.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%3EThe%20talk%20is%20also%20worth%20watching%20for%20the%20demo%20(%3CA%20href%3D%22https%3A%2F%2Fyoutu.be%2Fkd-F0M2_F3I%3Ft%3D2810%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ethe%20demo%20starts%20at%2046%3A52%3C%2FA%3E)%20where%20I%20compare%20the%20performance%20of%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fazure%2Fpostgresql%2Fquickstart-create-hyperscale-portal%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3EHyperscale%20(Citus)%3C%2FA%3E%20on%20%3CA%20href%3D%22https%3A%2F%2Fazure.microsoft.com%2Fservices%2Fpostgresql%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3EAzure%20Database%20for%20PostgreSQL%3C%2FA%3E%20against%20a%20single%20Postgres%20server.%20For%20the%20demo%2C%20I%20use%20GitHub%20archive%20data%20in%20an%20analytics%20use%20case%2C%20and%20the%20demo%20shows%20%26gt%3B250x%20speedups%20for%20analytical%20queries%20with%20Citus%3C%2FSPAN%3E%3CSPAN%3E!%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Citus-brings-PostgreSQL-to-any-scale-youtube-thumbnail-graphic-1200x630.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F218851i6DA6E41EE09E7A4F%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Citus-brings-PostgreSQL-to-any-scale-youtube-thumbnail-graphic-1200x630.png%22%20alt%3D%22Citus-brings-PostgreSQL-to-any-scale-youtube-thumbnail-graphic-1200x630.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CEM%3E%3CA%20href%3D%22https%3A%2F%2Fyoutu.be%2Fkd-F0M2_F3I%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3EClick%20here%20to%20watch%20the%20video%20of%20my%20talk%20at%20Warsaw%20PostgreSQL%20Users%20Group%3C%2FA%3E%2C%20on%20%3CSTRONG%3ECitus%3A%20PostgreSQL%20at%20any%20Scale%3C%2FSTRONG%3E.%20%3CA%20href%3D%22https%3A%2F%2Fyoutu.be%2Fkd-F0M2_F3I%3Ft%3D2810%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3EThe%20demo%20starts%20at%2046%3A52%3C%2FA%3E%3C%2FEM%3E%3CSPAN%3E%3CEM%3E%2C%20but%20the%20introductory%20discussion%20should%20be%20useful%2C%20too.%3C%2FEM%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%3EProps%20to%20the%20organizers%20of%20the%20Warsaw%20PostgreSQL%20Users%20Group%E2%80%94especially%20%3CA%20href%3D%22https%3A%2F%2Ftwitter.com%2FStiepanTrofimo%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3EAlicja%20Kucharczyk%3C%2FA%3E%E2%80%94for%20the%20time%20they%20spend%20organizing%20Postgres%20talks%20for%20their%20community.%20And%20for%20inviting%20me%20to%20give%20a%20talk%20to%20their%20Postgres%20users%20group.%20I%20really%20appreciated%20all%20the%20good%20questions%2C%20too.%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CH2%20id%3D%22toc-hId-1220808820%22%20id%3D%22toc-hId-1220808820%22%3E%3CSPAN%3EIf%20this%20is%20your%20first%20intro%20to%20Citus%20%26amp%3B%20you%20want%20to%20learn%20more%3C%2FSPAN%3E%3C%2FH2%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%3EHere%20are%20a%20few%20of%20the%20getting-started%20next%20steps%20I%20usually%20recommend%20to%20developers%3A%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3E%3CSTRONG%3E%3CSPAN%3EDownload%20Citus%20packages%20locally%3C%2FSPAN%3E%3C%2FSTRONG%3E%3CSPAN%3E%3A%20Citus%20is%20open%20source%2C%20so%20it%E2%80%99s%20easy%20to%20%3CA%20href%3D%22https%3A%2F%2Fwww.citusdata.com%2Fdownload%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Edownload%3C%2FA%3E%20and%20try%20out.%3CBR%20%2F%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FLI%3E%0A%3CLI%3E%3CSTRONG%3E%3CSPAN%3ETry%20Citus%20on%20Azure%3C%2FSPAN%3E%3C%2FSTRONG%3E%3CSPAN%3E%3A%20And%20in%20the%20months%20since%20%3CA%20href%3D%22https%3A%2F%2Fwww.citusdata.com%2Fblog%2F2019%2F01%2F24%2Fmicrosoft-acquires-citus-data%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3EMicrosoft%20acquired%20Citus%20Data%3C%2FA%3E%20last%20year%2C%20we%20have%20also%20integrated%20Citus%20into%20our%20managed%20Postgres%20service%20on%20Azure%3A%20Citus%20is%20now%20available%20as%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fazure%2Fpostgresql%2Fconcepts-hyperscale-choose-distribution-column%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3EHyperscale%20(Citus)%3C%2FA%3E%2C%20a%20built-in%20deployment%20option%20in%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fazure%2Fpostgresql%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3EAzure%20Database%20for%20Postgres%3C%2FA%3E.%20So%20you%20can%20also%20try%20out%20Citus%20on%20Azure.%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FSPAN%3E%3C%2FLI%3E%0A%3CLI%3E%3CSTRONG%3E%3CSPAN%3ERead%20the%20Citus%20open%20source%20docs%3C%2FSPAN%3E%3C%2FSTRONG%3E%3CSPAN%3E%3A%20%3CA%20href%3D%22https%3A%2F%2Fdocs.citusdata.com%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Edocs.citusdata.com%3C%2FA%3E%20has%20tutorials%20for%20multi-tenant%20SaaS%20applications%20and%20real-time%20analytics%20dashboards%2C%20a%20use%20case%20guide%20for%20time%20series%20data%2C%20details%20on%20pretty%20much%20every%20Citus%20feature%2C%20installation%20instructions%20for%20how%20to%20set%20Citus%20up%20locally%20on%20a%20single%20server%20as%20well%20as%20installing%20on%20multiple%20servers..%20the%20Citus%20docs%20are%20quite%20useful.%26nbsp%3B%20%26nbsp%3B%26nbsp%3B%3C%2FSPAN%3E%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-1667562%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Citus-brings-PostgreSQL-to-any-scale-with-Citus-elicorn-Azure-Postgres-icon-999x463.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F218850i9437FFEE8CADC6E8%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22Citus-brings-PostgreSQL-to-any-scale-with-Citus-elicorn-Azure-Postgres-icon-999x463.png%22%20alt%3D%22Citus-brings-PostgreSQL-to-any-scale-with-Citus-elicorn-Azure-Postgres-icon-999x463.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EBased%20on%20a%20Warsaw%20PostgreSQL%20Users%20Group%20talk%2C%20all%20about%20how%20Citus%20gives%20you%20Postgres%20at%20any%20scale.%20Includes%20a%20demo%20by%20our%20Citus%20open%20source%20technical%20lead.%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1667562%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECitus%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Edemo%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPerformance%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Microsoft

I recently gave a talk about the Citus extension to Postgres at the Warsaw PostgreSQL Users Group. Unfortunately, I did not get to go in person to beautiful Warsaw, but it was still a nice way to interact with the global Postgres community and talk about what Citus is, how it works, and what it can do for you.

 

If you are already familiar with Postgres then this talk should be a good introduction to all the powerful capabilities that Citus gives you. The tl;dr is this: Citus is an open source extension to Postgres that transforms Postgres into a distributed database. Citus uses sharding and replication to distribute your data and your Postgres queries across a distributed database cluster.

 

Shining a light on the performance speedups of Citus (via demo)

 

Every so often, I try to rethink how I talk about Citus as Postgres and the needs of applications evolve. One thing we have not done very much is talk directly about the performance improvements in Citus. Sometimes it’s actually slower, but at scale can be a lot faster. Therefore, I introduced every Citus feature with some benchmarks that show the performance compared to a (large) Postgres server.

 

The talk is also worth watching for the demo (the demo starts at 46:52) where I compare the performance of Hyperscale (Citus) on Azure Database for PostgreSQL against a single Postgres server. For the demo, I use GitHub archive data in an analytics use case, and the demo shows >250x speedups for analytical queries with Citus!

 

 

Citus-brings-PostgreSQL-to-any-scale-youtube-thumbnail-graphic-1200x630.png

Click here to watch the video of my talk at Warsaw PostgreSQL Users Group, on Citus: PostgreSQL at any Scale. The demo starts at 46:52, but the introductory discussion should be useful, too.

Props to the organizers of the Warsaw PostgreSQL Users Group—especially Alicja Kucharczyk—for the time they spend organizing Postgres talks for their community. And for inviting me to give a talk to their Postgres users group. I really appreciated all the good questions, too.

If this is your first intro to Citus & you want to learn more

 

Here are a few of the getting-started next steps I usually recommend to developers:

  • Download Citus packages locally: Citus is open source, so it’s easy to download and try out.
     
  • Try Citus on Azure: And in the months since Microsoft acquired Citus Data last year, we have also integrated Citus into our managed Postgres service on Azure: Citus is now available as Hyperscale (Citus), a built-in deployment option in Azure Database for Postgres. So you can also try out Citus on Azure.

  • Read the Citus open source docs: docs.citusdata.com has tutorials for multi-tenant SaaS applications and real-time analytics dashboards, a use case guide for time series data, details on pretty much every Citus feature, installation instructions for how to set Citus up locally on a single server as well as installing on multiple servers.. the Citus docs are quite useful.