Citus 13.0 is out! Now with PG17 Support. Read all about it in Naisila’s 13.0 blog post 💥
Citus 13.0 is out! Now with PG17 Support. Read all about it in Naisila’s 13.0 blog post 💥
Archive for April 2021
Made with from the Postgres team at Microsoft
|
Citus internals: how does it work?If you’ve always wanted to understand how Citus works, this is for you. Marco highlights 7 key moments in the video of his Carnegie Mellon talk about distributing Postgres with Citus. |
New Basic tier in Hyperscale (Citus)The new Basic tier that is in preview in Hyperscale (Citus) makes it easy to get started with Citus on Azure—and easy to shard Postgres even when your workload is small. And the cost is so much more affordable, Hyperscale (Citus) Basic tier in US East starts at $0.27 USD/hour. |
Citus interview on Hello WorldIf you only have 5 minutes to learn what Citus is, our friend Aaron recently interviewed Citus engine lead Marco Slot on the OSS Spotlight on Hello World. Aaron put together some useful Postgres & Citus resources, too. |
Why are SQL jokes the funniest?Because you can always EXPLAIN them! When Aaron Wislang (@as_w) was preparing to join Marco on the Hello World show to talk about Postgres, he & his friends had some puns. Thread. |
Windows team grows their petabyte Citus clusterThe Windows team uses Citus and Postgres on Azure to drive a petabyte-scale analytics dashboard. Min Wei’s use case has grown so much we had to update his customer story—from 6M queries/day to 10M queries/day, from 44 nodes to 54 nodes, from a P75 of 200ms down to 150ms. Now the P95 query response time is less than 1 sec across the board. |
Citus on Azure is a thingYep, Citus is available in the cloud as Hyperscale (Citus), a built-in option in the Azure Database for PostgreSQL managed service. With a whole bunch of useful new features in preview. |
Shard rebalancer, now open sourceThere’s lots to be happy about with the Citus shard rebalancer. It’s now open source—and in addition to the 2 built-in rebalance strategies, you can add your own custom rebalance strategy too. |
Columnar compression in CitusIf you missed the news about Citus 10 columnar compression, drink up. There’s also a video demo—and some useful a timeseries docs about using Citus columnar with Postgres partitioning. |
New goodness in Flexible ServerOur Azure teammates who work on the Flexible Server managed service for Postgres are pretty jazzed about some of the new capabilities in Flexible Server (in preview.) |
Single docker run commandDid you know you can now run Citus open source on a single node with just a single docker run command? New as of Citus 10. |
Revamped Citus READMEAs part of the Citus 10 rollout we completely revamped the way we explain Citus in our GitHub README. We’d love to know what you think! |
ICYMI: the definitive Citus 10 postWe can’t wait to see what you do with Citus 10. And if you haven’t yet read Marco’s blog post, the tl;dr is that Citus 10 gives you a spectacular set of new capabilities. |
You May Also Like |
Update to Heap's story on Citus from Dan Robinson, on the Citus website |
When to use Hyperscale (Citus) to scale out Postgres by Claire Giordano on the Citus Blog |
by David Rowley on Microsoft TechCommunity |
Don’t let collation versions corrupt your Postgres indexes by Thomas Munro on TechCommunity |
New table of Citus capabilities by the Citus team on the Citus website |
|
Events & Conference Talks |
On May 5th: Citus on Data Exposed Live Claire Giordano | Streaming live on LearnTV, YouTube, Twitch, and Twitter |
Upcoming talk on Open Source Databases Online | May 10-12 | Alicja Kucharczyk & Haider Raza |
May 14 | Anthony Shaw | Deploying your Django app for scale with Azure |
Video: Marco’s Citus talk @ CMU Video | Marco Slot | Vaccination Database talks |
Video: The Story About the Migration Video | Alicja Kucharczyk & Sushant Pandey | FOSDEM 2021 |
|
Is Citus right for you? |
Ways to get started: download Citus, check out the inspired Citus documentation, visit our open source repo on GitHub, or watch Marco’s SIGMOD demo using HammerDB to measure the performance of Hyperscale (Citus) in Azure Database for PostgreSQL. |
A monthly email with the latest posts about Postgres & the Citus database extension
Made with from the Postgres team at Microsoft
This site uses cookies for analytics, personalized content and ads. By continuing to browse this site, you agree to this use. Learn more.