Sharing this overview of the #PostgreSQL work done at Microsoft over the last 12 months. I'm in awe of my teammates, & the many other ppl in PG world we collaborate with 🙌

The workstreams:
- Postgres open source
- Citus database extension
- PG ecosystem e.g. Patroni, PgBouncer, pgcopydb, pg_cron...
- PG community work
- #AzureDBPostgres
- #AzureCosmosDB for PostgreSQL

+1 to the many ppl who reviewed this post & helped bring it to life #OpenSource #Postgres #Citus
https://techcommunity.microsoft.com/t5/azure-database-for-postgresql/what-s-new-with-postgres-at-microsoft-august-2023/ba-p/3914506

So I'm back from sailing and today is PGSQL Phriday (weird spelling I know) and the topic for today's community Postgres blogging event is "Partitioning vs. Sharding", a topic that is right up my alley!

So here is my blog contribution on Understanding Partitioning and Sharding in Postgres, featuring the Citus database extension in the sharding section of course!

#PostgreSQL #PGSQLPhriday #Citus #databases #OpenSource #blogging #Postgres

https://www.citusdata.com/blog/2023/08/04/understanding-partitioning-and-sharding-in-postgres-and-citus/

The post discusses a potential idea for a GPT plugin for Citus shard key selection in PostgreSQL. The plugin would allow users to select the best shard key for their PostgreSQL database based on their usage patterns. The post provides a brief overview of Citus and explains the benefits of using shard keys for scaling out... https://techcommunity.microsoft.com/t5/azure-database-for-postgresql/idea-for-gpt-plugin-citus-shard-key-selection-in-postgres/ba-p/3829172 #PostgreSQL #Citus #softcorpremium

It's the last day of May and today's #CitusCon video of the day is by @cyberdemn of Microsoft, who is the lead of the Patroni project for PostgreSQL...

If you want to learn about the key to scalable (horizontally scalable) & fault-tolerant PostgreSQL, watch this talk (and demo) about Citus and Patroni.

https://aka.ms/cituscon-alexanderk-2023

#PostgreSQL #Citus #databases #Patroni #Microsoft #OpenSource #HighAvailability

Idea for GPT Plugin: #Citus Shard Key Selection in #Postgres https://techcommunity.microsoft.com/t5/azure-database-for-postgresql/idea-for-gpt-plugin-citus-shard-key-selection-in-postgres/ba-p/3829172

Today's video of the day from <Citus Con: An Event for Postgres 2023> is by Matt Klein & Delaney Mackenzie from the engineering team at Jellyfish.co, all about the challenges & lessons migrating their multi-tenant SaaS application from RDS Postgres over to Citus.

https://aka.ms/cituscon-delaney-matt-2023

#PostgreSQL #Postgres #Citus #CitusCon #Jellyfish #Microsoft #SaaS #database

So excited 💥 this week I get to talk to magical & genius #PostgreSQL people @tchorix & @alvherre on #PathToCitusCon which is a new live show on Discord, like a podcast 🎙️ with live text chat @ same time ⌨️ Along w/my co-host Pino de Candia of #Microsoft #azure

Happening Wed May 3rd @ 10:00am PDT on Discord 📆

Boost please to help more people learn about this 📣

Mark your calendar & join us ✅ https://aka.ms/PathToCitusCon-Ep03-cal
#podcast #discord #postgres #Citus #events #community

Yikes, I am in the home straight before Citus Con: An Event for Postgres 2023, our 2nd annual virtual event happening:

- Tue Apr 18 @ 9am PDT
- Wed Apr 19 @ 9am CEST

Who do I know on Twitch who has #PostgreSQL followers & would be willing to "raid" the Twitch livestream from #Microsoft Developer for the 2 #CitusCon livestreams? Boosts welcome!

@nova would you—or do you know anybody whose Twitch ppl care about #postgres

#Twitch #CitusCon #Citus #Database https://aka.ms/cituscon

@simon @marcoslot This event is organized by the #PostgreSQL and #Citus teams at #Microsoft! So big +1 of gratitude 🙌 to all the organizers who I know will be working quite hard up until the day of the event to make sure that all the speakers—and all the attendees—are delighted!

There are 37 amazing talks @ the Apr 18-19 free & virtual Citus Con: An Event for Postgres 2023.

Please boost 💥 to spread the word to your friends who use #PostgreSQL 🐘 so they add this to their calendars & join the livestreams + virtual hallway track on Discord? 👀

Each of 2 livestreams has 6 talks + there are 25 on-demand talks that will publish at start of #CitusCon

@simon & @marcoslot = keynoters!

Schedule details: https://aka.ms/cituscon
#Citus #OpenSource #Azure #Microsoft

I wrote a new "ultimate guide" ✒️ for those who work with (or want to learn more about) Postgres &/or Citus &/or querying data—to help you pick which 37 talks to watch & which livestreams to attend @ the upcoming free & virtual:

- Citus Con: An Event for Postgres 2023 on Apr 18-19, 2023

Keynote speakers 💥 = @simon & @marcoslot. If #CitusCon is your jam, mark your calendar (links in post) & boost to friends. 📣

#PostgreSQL #Citus #Postgres #events #Microsoft #conference https://www.citusdata.com/blog/2023/03/31/ultimate-guide-to-citus-con-2023/

If you are #Patroni user and interested about #Citus, or if you are a #Citus user and want to run it with #HA and automatic failover, or even (especially) if you never heard about neither #Citus nor #Patroni, then you will find interesting to read a new blog post: https://www.citusdata.com/blog/2023/03/06/patroni-3-0-and-citus-scalable-ha-postgres/

It explains how the new Patroni 3.0 release integrates with Citus extension to PostgreSQL and makes the best of two worlds - #Scalable and Fault-Tolerant #PostgreSQL!

So as the clock ticks and we get closer to Citus Con: An Event for Postgres 2023, it seemed fitting to release my video monologue as a YouTube #Short.

It's about the often misspelled, often mispronounced Postgres and Citus databases.

Hope y'all enjoy it and that it brings a smile to your day.

Please please boost, to help more people get a kick out of this.

#PostgreSQL #CitusCon #Citus #Postgres #YouTube #video #humor

https://youtube.com/shorts/M_91z3gMW2A?feature=share

Following the example of the VS Code team with their release parties for each new VS Code release...

Tomorrow/Tuesday Feb 21st at 9am PST I'll be co-hosting a livestream of the 11.2 release event for the Citus database extension to Postgres—along w/my co-host Jelte Fennema.

There will be 3 cool demos by Jelte, @mulander, & @marcoslot

Join us. Pls boost to your #PostgreSQL friends!

#Citus #Postgres #database #livestream #Microsoft #opensource

https://www.youtube.com/watch?v=LxIOqhsW7VI

@tmunro Have you connected with @nova and team to understand how they're optimizing and improving hachyderm.io?

I think I can send you the link to their Discord....as can Kris!

(And I still find myself wondering if distributing Postgres with the Citus database extension would be useful but that's something you'd be better able to assess)

#Postgres #PostgreSQL #mastodon #Citus #database

Earlier today I posted about the 11.2 open source release of the Citus database extension, w/link to Marco's blog post on #Citus 11.2.

But I think this post on the birdsite by @marcoslot is more to the point. From Marco:

"A lot of work went into the new version of Citus that went out on Friday. Most of it was done by our talented engineering team in Turkey, which along with Syria is going through a disaster of unimaginable scale.

One way to help is below"
#earthquake

https://www.kizilay.org.tr/Bagis/BagisYap/405/donations-for-earthquake-in-pazarcik

So today we dropped the 11.2 open source release of the Citus database extension for Postgres!!

Here is the post about Citus 11.2 written by @marcoslot (who is not yet active on Mastodon but hopefully will be over time!)

One of the cool things that released in the same timeframe is Patroni 3.0 support for Citus high availability (page @cyberdemn for more details if you're interested in that.)

#PostgreSQL #Postgres #Citus #Patroni #database #OpenSource #Microsoft

https://www.citusdata.com/blog/2023/02/08/whats-new-in-citus-11-2-patroni-ha-support/

There are just a few days left to submit your talk proposals into the CFP for Citus Con: An Event for Postgres 2023!

The CFP will close on Sunday Feb 5th @ 11:59pm PST. Please boost to help spread the word.

If your talk proposal is accepted, you'll be able to record your talk from the comfort of your own desk, since the event is virtual.
#CFP #CfS #CallForSpeakers #PostgreSQL #Postgres #Citus #CitusCon
https://www.citusdata.com/cituscon/2023/cfp/

Current status, about to visit with an old friend before going into the Citus database team’s Amsterdam engineering office. #Coffee is involved of course #Amsterdam #doppio #Citus

As I prep for my talk at #FOSDEM this coming weekend in Brussels, I just took a screenshot of the open source repo for the Citus database extension on GitHub.

It would be soooo lovely if this Citus repo hits 8K stars before my talk this weekend. Why? Because social proof matters. If you're a fan / user / supporter, maybe let the world know?

#PostgreSQL #Citus #GitHub #Postgres #community #opensource #FOSDEM2023

https://github.com/citusdata/citus