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 September 2020
Made with from the Postgres team at Microsoft
|
What’s new in the Citus 9.4 extension to Postgres ⟶ Citus 9.4 is all about performance. In this post, you’ll learn about all the latest goodness in Citus open source. Things like EXPLAIN ANALYZE improvement, COPY connection management, calculating percentiles with t-digest, a new optional binary protocol, & more. Read on. BLOG | MARCO SLOT |
Diary of an Engineer: Delivering 45x faster percentiles using Postgres, Citus, & t-digest ⟶ Sometimes customers have unique challenges. In this popular post, Nils explores how he—with the help of the Postgres community—was able to reduce percentile calculations from ~6 minutes to just 7.5 seconds for a customer. And there’s more on t-digest from Stackify and the Windows team at Microsoft too. BLOG | NILS DIJK |
Mining for logic bugs in the Citus extension to Postgres with SQLancer ⟶ This! A post about using SQLancer to mine for database logic errors in Citus & Postgres by our Stanford engineering intern. BLOG | NAZLI UGUR KOYLUOGLU |
DEMO: Performance of Citus & Postgres at any scale ⟶ At the Warsaw Postgres Meetup, Marco shined a light on the performance speedups gained with Citus. Read on for a link to his demo, and guidance on next steps for those new to Citus. BLOG | MARCO SLOT |
Postgres 13 has arrived and with it highly requested features like parallelized vacuuming and incremental sorting. And there’s significant improvements to its indexing and lookup system that benefit large databases too. Like space savings and performance gains for indexes, faster response times for queries that use aggregates or partitions, better query planning when using enhanced statistics, and more. BLOG | POSTGRESQL DEVELOPMENT GROUP |
Helsinki Regional Transportation Authority (HSL) reduces costs by over 50% ⟶ In this intriguing customer story, learn how HSL achieved much better performance and reduced operational cost by >50% with Hyperscal (Citus) on Azure Database for Postgres. CUSTOMER STORY | HSL |
pg_auto_failover 1.4 released ⟶ In this tweet, @tapoueh announced pg_auto_failover 1.4. The ability to handle any number of standby nodes is the main focus of this release. And, PostgreSQL 13 support is included too. RELEASE NOTES | DIMITRI FONTAINE |
Taking the RedwoodJS tutorial wheels off and using a Postgres database on Azure ⟶ Delightful technical writing with just the right amount of humour from Kim-Adeline Miguel: a step-by-step tutorial on how to plug a Postgres database into a RedwoodJS app, using the Postgres managed database service on Azure. TUTORIAL | KIM-ADELINE MIGUEL |
Introducing Flexible Server for Azure Database for PostgreSQL ⟶ Some big news from our Azure team at Ignite. Flexible Server, a new deployment option, provides fine-grained database tuning with multiple configuration parameters & a simpler developer experience. BLOG | SUNIL KAMATH |
More news from Ignite—Azure Arc data services in preview ⟶ Azure Arc enables you to run Azure data services on-premises, at the edge, and multi-cloud—using Kubernetes on the hardware of choice. And Postgres Hyperscale (powered by the Citus extension) is one of the first data services available. BLOG | ASAD KHAN |
ICYMI: Bitnami provides production-ready solutions using Postgres in Azure ⟶ Get the deets on Bitnami’s collaboration with Microsoft—with links to Bitnami templates for Postgres on Azure, for Apache Airflow, & for using CKAN with Hyperscale (Citus). BLOG | SUNITHA MUTHUKRISHNA |
You May Also Like |
Scalable Cloud Environment for Distributed Data Pipelines with Apache Airflow ⟶ INFOQ BLOG | APACHE AIRFLOW, DATA PIPELINES, KUBERNETES, POSTGRES |
Postgres Person of the Week: Thomas Munro ⟶ BLOG | COMMITTER, HACKING, CYCLING, CRASH RECOVERY |
Using PostgreSQL pgoutput plugin for change data capture with Debezium on Azure ⟶ TUTORIAL | PGOUTPUT, AZURE PORTAL, AZURE CLI, AZURE POWERSHELL |
A history lesson on SQL joins (in Postgres) ⟶ BLOG | CROSS JOINS, WHERE FILTERS, INNER & OUTER JOINS, DISTRIBUTED JOINS |
Marco Slot - Postgres Person of the Week ⟶ BLOG | HAARLEM, PGSQL-HACKERS, DISTRIBUTED CARS, CITUS |
Fun with SQL: generate_series in Postgres ⟶ BLOG | INTEGERS, TIMESTAMPS, CTE, JOINS |
|
Events & Conference Talks |
Video: Oracle to PostgreSQL migration with ora2pg from LOAD 2020 ⟶ In her talk Alicja shares both why and how you can easily migrate from Oracle to Postgres |
Running Your Own Postgres Database as a Service on Kubernetes ⟶ Slides from Lukas Fittl’s presentation at Linux Foundation Open Source Summit |
Performance demo of Hyperscale (Citus), with side-by-side comparison ⟶ SIGMOD demo showing side-by-side comparison of Hyperscale (Citus) and single node Postgres |
News about our Azure Database for Postgres managed service ⟶ Slides from our Ignite presentation announcing Flexible Server, a new Azure Database for Postgres deployment option |
|
Is Citus right for you? |
Want to explore whether Citus is right for you and your use case? Download Citus open source, check out the documentation, or watch this short demo of Hyperscale (Citus) on 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.