The schedule is out 🗓️ for POSETTE: An Event for Postgres 2026!
The schedule is out 🗓️ for POSETTE: An Event for Postgres 2026!
Archive for November 2020
Made with from the Postgres team at Microsoft
|
|
| All about the new features, the refactoring, and the quality work we poured into Citus 9.5. We think you’ll be delighted. And if you need the nitty gritty details, check out the changelog on GitHub. BLOG | CLAIRE GIORDANO |
| Making Postgres stored procedures 9x faster ⟶ Marco tells the story of how the team made Postgres stored procedures 9x faster (or is it 19x faster?) in Citus, using the HammerDB benchmark to measure progress. BLOG | MARCO SLOT |
| Analyzing GPS trajectories at scale ⟶ A useful "how to" guest post on analyzing geospatial movement trajectories by combining some of our favorite Postgres extensions: PostGIS, MobilityDB, and Citus. BLOG | MAHMOUD SAKR |
| Azure CLI tips for Flexible Server and Postgres ⟶ Do you prefer using a CLI? Here are some useful tips for using the Azure CLI with Flexible Server, a new single server deployment option (in preview) for Postgres on Azure. BLOG | SUNITHA MUTHUKRISHNA |
| GitHub README for pg_auto_failover ⟶ pg_auto_failover is an open source extension that monitors and manages automated failover for Postgres. To learn what Dimitri's been up to on this project, this README is a solid place to start. GITHUB | DIMITRI FONTAINE ET AL |
| Choosing a distribution column ⟶ An important decision when sharding Postgres with Citus is deciding what your distribution column will be. If you are at this point in your Citus journey, these docs should be super useful. DOCS | CITUS OPEN SOURCE |
| News: PostgreSQL 13.1, 12.5, 11.10, 10.15, 9.6.20, and 9.5.24 released ⟶ The PostgreSQL global development group released an update in mid-November to all supported versions of Postgres. Why? To close 3 security vulnerabilities & fix over 65 bugs filed in the last 3 months. NEWS | POSTGRESQL GLOBAL DEVELOPMENT GROUP |
| 45% off holiday discount for The Art of PostgreSQL ⟶ We have heard so many +1s about Dimitri's book that teaches SQL to developers. So we asked Dimitri for a discount to share with you. With the "CitusHolidays45" coupon code, you get 45% off this fabulous book in December. BOOK | DIMITRI FONTAINE |
| Welcome to new PostgreSQL core team members ⟶ An announcement from the PostgreSQL core team. The gist is they’ve increased the core team from 5 people to 7. Big welcome to Andres Freund & Jonathan Katz. NEWS | POSTGRESQL CORE TEAM |
| Use case guide on real-time analytics ⟶ During a conversation on Twitter last week, we realized not everyone knows about this use case guide on using Citus to power real-time analytics dashboards. Here's to hoping it is everything Jonathan imagines it to be. DOCS | CITUS OPEN SOURCE |
| Interactive Postgres Observability diagram ⟶ If you want to understand the different Postgres systems that enable you to observe and monitor, this interactive diagram is your ticket. Kudos to Alexey Lesovsky at Data Egret for creating it. DATAVIZ | ALEXEY LESOVSKY |
| ICYMI Analyzing the Limits of Connection Scalability in Postgres ⟶ A deep dive into why Postgres doesn’t handle large numbers of connections particularly well. And once you’ve read it, you'll likely enjoy Part 2, on improving Postgres connection scalability in Postgres 14. BLOG | ANDRES FREUND |
| You May Also Like |
| BLOG | COUNTS, ESTIMATES, DISTINCT COUNTS |
| Distributed Execution of Subqueries and CTEs in Citus ⟶ BLOG | CTEs, DISTRIBUTED DATABASES, QUERY PLANNER |
| Full-text search since PostgreSQL 8.3 ⟶ BLOG | SEARCH, INDEXING, FULL-TEXT SEARCH, HISTORY |
| My GSoC with PostgreSQL: even faster and safer backup restoration in WAL-G ⟶ BLOG | WAL-G, GO, SUMMER OF CODE, PERFORMANCE |
| Collection of "deep dive" blog posts ⟶ BLOG COLLECTION | DEEP DIVE, POSTGRES, CITUS, DATABASES |
|
|
| Events & Conference Talks |
| Join our speakers at Postgres Build Dec 8-9 ⟶ Postgres Build is happening Dec 8-9: we hope you tune in to Dimitri's talk on Postgres Architectures in Production; also, Alicja's and Shushant's talk about migrating from Oracle to Postgres. |
| Join this meetup / interview with Andres Freund on Dec 15 ⟶ When the Swedish and Polish Postgres communities come together, good things happen. This time, it's an interview with Andres Freund. Enjoy. |
| Join our talk at Data Platform Summit on Azure Arc & PostgreSQL ⟶ On Dec 2-5, a nonstop 72 hour virtual event that includes a talk about Azure Arc and PostgreSQL Hyperscale (featuring Citus.) |
| Architecting petabyte-scale analytics with Citus ⟶ Slides on Speaker Deck from Alicja Kucharczyk's recent talk about scaling out Postgres on Azure with Citus. |
| Optimize Python apps with Postgres superpowers ⟶ Video from Louise Grandjonc's PyCon workshop on how to optimize your Python & Django apps. This talk is a delight. |
|
|
| 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 showcasing the performance of Hyperscale (Citus) on Azure Database for PostgreSQL. |
This site uses cookies for analytics, personalized content and ads. By continuing to browse this site, you agree to this use. Learn more.