POSETTE 2024 is a wrap! 💯 Thanks for joining the fun! Missed it? Watch all 42 talks online 🍿
POSETTE 2024 is a wrap! 💯 Thanks for joining the fun! Missed it? Watch all 42 talks online 🍿
Archive for October 2020
Made with from the Postgres team at Microsoft
|
|
| Analyzing the limits of connection scalability ⟶ Postgres doesn't handle large numbers of connections particularly well. Ever wonder why? Andres analyzes the contributing factors: Postgres memory usage, snapshot scalability, & the connection model. BLOG | ANDRES FREUND |
| What's new in pg_auto_failover for HA ⟶ The latest from Dimitri about what's new in pg_auto_failover 1.4, a Postgres utility built for HA that monitors & manages failover. The biggest news: multi-standby support. BLOG | DIMITRI FONTAINE |
| Improving Postgres connection scalability: Snapshots ⟶ Part 2 of this blog series about the performance improvements for connection scalability in Postgres 14. Includes before & after comparisons, plus a useful primer on MVCC and snapshots. BLOG | ANDRES FREUND |
| Migrating from Redshift to Citus ⟶ Sai recently migrated a customer from Redshift to Hyperscale (Citus) in just 2 weeks. Things that helped: JSONB, the parallelization of SQL queries with Citus, and the speedups of Postgres indexes. BLOG | SAI SRIRAMPUR |
| Who doesn't love pg_cron? With pg_cron, you can schedule your Postgres queries to run periodically. Marco's post covers all the new things, including PG 13 support. +1 to the collaboration between Postgres engineers at Microsoft, Amazon, & Zalando. BLOG | MARCO SLOT |
| Measuring the memory overhead of a Postgres connection ⟶ Turns out measuring the memory overhead of a Postgres connection is surprisingly hard. This measurement was an important part of Andres’s analysis of the connection scalability issues in Postgres. BLOG | ANDRES FREUND |
| What is Flexible server in Azure Database for PostgreSQL? ⟶ The new Flexible Server option (in Preview) for Azure Database for PostgreSQL uses the same platform architecture as Hyperscale (Citus), albeit for a single node. Here's the canonical "what is" post from Sunil—or you can check out the Azure docs instead. BLOG | SUNIL AGARWAL |
| Statement from the PostgreSQL core team ⟶ The recent EDB acquisition of 2ndQuadrant has caused a majority of the Postgres Core Team's members to be employed by EDB, breaking the age-old unwritten rule. Resolving this is a work in progress. NEWS | POSTGRESQL CORE TEAM |
| Learn how to migrate on-prem Postgres databases to the cloud ⟶ A how-to for creating an Azure Database for PostgreSQL server & migrating on-prem databases to Azure. Talks about Citus on Azure, too. DOCS | LEARN TEAM |
| Azure Arc Is a Control Plane to Orchestrate Hybrid Cloud ⟶ Azure Arc-enabled data services is now in Preview and Mary Branscombe does a good job explaining what it's all about. We like that one of the first database services in Azure Arc is Postgres. ARTICLE | MARY BRANSCOMBE |
| ICYMI: What's new in Citus 9.4 ⟶ All about the latest open source release of Citus. From EXPLAIN ANALYZE improvements, to better COPY connection management, to Citus downgrade scripts—lots of good stuff here. BLOG | MARCO SLOT |
| You May Also Like |
| How to convert 2 Billion Rows to Bigint ⟶ BLOG | INTEGER OVERFLOW, BIGINT, SCALE, CITUS, CONVERTFLOW |
| Creating a scalable time-series database with Citus & pg_partman ⟶ BLOG | POSTGRES, TIME SERIES, PG_PARTMAN, CITUS, SCALE |
| Monitoring your bloat in Postgres ⟶ BLOG | BLOAT QUERY, AUTOVACUUM |
| Scaling real-time analytics dashboards ⟶ BLOG | ANALYTICS, ROLLUPS, INSERT..SELECT, CITUS, PG_CRON AUTOMATION |
| Video of an interview & demo about Citus for mixed workloads ⟶ VIDEO | CITUS, DISTRIBUTED POSTGRES, DEMO, INTERVIEW, PERFORMANCE |
| Tour of Postgres Index Types ⟶ BLOG | INDEX TYPES, B-TREE, GIN, GIST, BRIN, HASH |
|
|
| Events & Conference Talks |
| New event: Postgres Build in Dec 2020 ⟶ Just announced: a Postgres event on 08 & 09 December. Virtual, of course. Move fast: the CFP deadline is 08 Nov 2020. |
| Signups are open for #OpenAzureDay ⟶ Open Azure Day is on 18 November. And Sridhar, one of our teammates, will be giving a talk about our Postgres service on Azure. |
| Video from Alicja's Cloud Native London talk ⟶ Watch Alicja Kucharzyck's talk about architecting petabyte-scale analytics by scaling out Postgres on Azure. With Citus of course. Alicja's slides are useful, too. |
| FOSDEM 2021 Call for Participation ⟶ No one is surprised: FOSDEM is going virtual in 2021. And it's time to move: devroom proposals are due 31 Oct. |
| About Flexible Server in Azure Database for PostgreSQL ⟶ Video of Lukas's recent #MSIgnite talk about the new Flexible Server option for Azure Database for PostgreSQL. |
|
|
| 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.