The schedule is out 🗓️ for POSETTE: An Event for Postgres 2026!
 |
|
|
| The latest version of Citus, all about Citus 9.3 ⟶ All the things in the latest open source release of Citus. Ft. improved window functions, adaptive connection management, shard pruning, pg_dump, & more. Read Claire’s blog. BLOG | CLAIRE GIORDANO |
| How to convert 2 billion rows to Bigint ⟶ With 2 billion rows in distributed Citus tables & an integer primary key set to autoincrement, our ConvertFlow customer would soon have an integer overflow issue. Here’s how Colton solved the problem. BLOG | COLTON SHEPARD |
| Propagation of custom types in Citus ⟶ Automated dependency propagation solves a long-time headache for custom types and Postgres extensions in Citus. This is Nils’s take on why you should care. BLOG | NILS DIJK |
| High performance HTAP with Postgres & Citus, a video with demo ⟶ This interview & demo—created from our work-from-home Covid-era offices for the recent European Open Source Summit—explores how you can use Citus to serve both transactional & analytical workloads at scale. Marco's demo is a must-see. VIDEO | CLAIRE GIORDANO & MARCO SLOT |
| Discussion on recent Jepsen report on PostgreSQL 12.3 ⟶ This comment thread on Hacker News is as interesting as the Jepsen report itself. Especially this quote from Kyle Kingsbury: "the PostgreSQL team really knocked it out of the park on this one." HN COMMENT THREAD |
| Video of Citus co-founder’s latest talk about Azure and Postgres ⟶ Even before acquiring Citus, the team at Microsoft has been investing more and more in Postgres. In this video, Umur shares his perspective on what makes Azure unique for Postgres. VIDEO | UMUR CUBUKCU |
| 20% off discount for Dimitri Fontaine’s book, The Art of PostgreSQL ⟶ With the discount code of "CITUS" you get 20% off Dimitri’s awesome book on Postgres, created to help developers replace 1000s of lines of code with simple SQL queries. BOOK | DIMITRI FONTAINE |
| PostgreSQL 13 Beta 2 is released ⟶ Good news: the 2nd beta release of PostgreSQL 13 is now available for download, including previews of all the new Postgres 13 features. POSTGRESQL GLOBAL DEVELOPMENT GROUP |
| Migrating from Oracle to PostgreSQL ⟶ Here are the slides from this oversubscribed talk (on a popular topic) from Sai & Saurabh. Of course the talk was higher fidelity than the slides, but since the video hasn’t dropped yet we thought we would at least share these. SLIDES | SAI SRIRAMPUR & SAURABH MODI |
| Optimizing Django & Python performance ⟶ Louise wrote this to share highlights of her PyCon2020 video on how to optimize Django & Python performance. Check out the blog (& then watch the video.). BLOG | LOUISE GRANDJONC |
| ICYMI: What makes spatial queries special, ft. PostGIS & Postgres ⟶ Tips & tricks for working with spatial joins & spatial queries with PostGIS, from our guest blogger Topi Tjukanov. Learn how to know thy neighbour with PostGIS in this post. BLOG | TOPI TJUKANOV |
| You May Also Like |
| How to configure Postgres log settings ⟶ BLOG | POSTGRES LOGS |
| From Brandur, doubling the sorting speed of Postgres network types ⟶ BLOG | TYPES, INET, CIDR, BITMASK |
| Tutorial: design a multi-tenant database with Hyperscale (Citus) ⟶ DOCS | MULTI-TENANCY, AZURE, CITUS |
| Postgres planner & CREATE STATISTICS ⟶ BLOG | EXPLAIN, PG_STATISTIC, EXPLAIN ANALYZE, N_DISTINCT |
| Choosing a distribution column in Hyperscale (Citus) ⟶ DOCS | SHARDING, TIMESERIES, MULTI-TENANT, REAL-TIME ANALYTICS |
| Citus 9.2 speeds up large scale HTAP workloads on Postgres ⟶ BLOG | CTE, AGGREGATES, JOINS, HTAP |
|
|
| Events & Conference Talks |
| Asynchronous IO for PostgreSQL ⟶ Andres Freund has been working hard on a new Async IO system for Postgres. Here are the slides from his PGCon 2020 virtual talk. |
| Reducing I/O & memory stalls ⟶ If you can’t wait until the video drops to get a glimpse into Thomas Munro’s PGCon talk on reducing I/O and memory stalls, these slides are for you. |
| What’s Missing for Postgres Monitoring ⟶ If you’ve ever seen Lukas Fittl speak, you’ll know he’s passionate about monitoring. Here are his PGCon slides. |
| News, observations, and speculation in this slide deck from Thomas Munro’s BSDCan virtual talk. |
| How to Scale Postgres: Automation, Tuning & Sharding ⟶ Alas, all our conference talks are virtual these days. Here are Lukas Fittl’s awesome slides from his June Postgres Vision talk. |
| High performance HTAP with Postgres & Citus ⟶ Slides from Claire Giordano’s interview with Marco Slot at the Microsoft European Virtual Open Source Summit (that’s a mouthful), complete with a side-by-side performance comparison of Hyperscale (Citus) vs. Postgres running on a single node. |
|
|
| 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. |