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 April 2023
Made with from the Postgres team at Microsoft
|
Citus Con: An Event for Postgres 2023 is a wrap!Our virtual Postgres event is over, but you can still watch the Citus Con talks! All 25 on-demand talks are available on YouTube—both livestreams are too. This “Ultimate Guide” blog post helps you find the PG talks you didn’t know you needed. |
Watch Simon Willison’s keynote: Big Opportunities in Small DataIn his Citus Con 2023 keynote, Simon Willison of Django fame explores the world of small data, and the open-source multi-tool he created for exploring, analyzing, & publishing data. |
Watch Marco’s keynote about the Distributed PostgreSQL problemIn his Citus Con 2023 keynote, Marco Slot, lead architect for Citus, shares the main engineering challenges developing Citus—the fastest & most mature Distributed PostgreSQL implementation. |
Join Boriss & Álvaro for Path To Citus Con Ep03 on Wed May 3rdPath To Citus Con has a life of its own—now a monthly live show on Discord. With guests Boriss Mejías & Álvaro Herrera, Episode 3 is about why giving talks at Postgres conferences matters. |
Demo of How to auto-scale Azure Cosmos DB for PostgreSQL with Citus, Grafana, & Azure ServerlessPut off by the manual steps required to scale your Postgres database? Lucas demos how to auto-scale Postgres on Azure. |
Video: Postgres & Artificial IntelligenceBruce Momjian describes how to do machine learning inside a Postgres database & its specific advantages in this talk from Citus Con 2023. |
Video: Implementing Temporal Features in PostgreSQLWhat is temporal data? What are the relationships between SQL standard & bi-temporal data implementation in Postgres? Find out this & more in Hettie’s talk. |
Video: Optimizing Postgres for Write-Heavy WorkloadsIn his talk from Citus Con, Samay shares his performance recommendations for write-heavy workloads, featuring checkpoint and WAL configs. |
Data Encryption at rest with Customer Managed keys for Citus on AzureWith customer-managed encryption, you’re in full control of a key’s lifecycle, key usage permissions, and auditing of operations on keys. |
Partitioning strategy for Oracle to Postgres migrations on AzureIn this Citus Con talk, learn from Adi about how to migrate partitions from Oracle to Postgres. |
Lessons learned: Migrating from AWS-Hosted PostgreSQL RDS to Self-Hosted CitusMatt & Delaney share their Python/Django journey to stand up a robust and reliable self-hosted Citus infrastructure. |
Video about Citus on KubernetesIf you want to scale Postgres with Citus on Kubernetes, this is your talk. Álvaro demos how to automate Citus sharded cluster creation & much much more. |
ICYMI: Patroni 3.0 & Citus: Scalable, Highly Available PostgresA post for people who care about distributed PostgreSQL and High Availability. A deep dive into the Patroni 3.0 HA integration with the Citus database extension to Postgres. |
In Case You Missed It |
Representational State Transfer (REST) APIs for Citus on Azure are generally available from Azure Cosmos DB for PostgreSQL docs |
Working in public on open source – Listen from Path To Citus Con Episode 01 |
Listen to Path To Citus Con podcast, Ep02 How to get Postgres ready for the next 100 million users |
|
Events & Conference Talks |
PGConf NYC 2023 – CFP open until Jun 12th New York, NY | Oct 3-5, 2023 |
PGCon 2023 – Sessions announced! Ottawa, Canada | May 31-Jun 1, 2023 |
Patroni 3.0: What’s New and Future Plans Alexander Kukushkin | PGCon 2023 |
The Chronicles of Sort Performance in PostgreSQL David Rowley | PGCon 2023 |
Adding PG15 Support to Citus Extension: Strategies & Lessons Learned Hanefi Onäldi | PGCon 2023 |
Visualizing PostgreSQL I/O Performance for Development Melanie Plageman | PGCon 2023 |
Thomas Munro | PGCon 2023 |
Strasbourg, France | Jun 19-20, 2023 |
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 (now known as Azure Cosmos DB 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.