Mastodawn

mulander Dec 8, 2023

Claire Giordano ✨Dec 8, 2023

Hot off the press—just in time for #PGConfEU, a new #PathToCitusCon podcast 🎙️ for developers who love #PostgreSQL with a-ma-zing guests @lukas & Rob Treat!

Good weekend listening 🎧 about: My Journey into Postgres Monitoring 📈

Hosting this podcast w/ Pino de Candia is one of the most fun parts of my #PostgreSQL community work & I hope y'all love it. ❤️

You can listen & subscribe on all the podcast platforms! Boosts appreciated 🙌

#podcast #database #monitoring

https://pathtocituscon.transistor.fm/episodes/my-journey-into-postgres-monitoring-with-lukas-fittl-rob-treat

Path To Citus Con, for developers who love Postgres | My Journey into Postgres Monitoring with Lukas Fittl & Rob Treat

Path To Citus Con is for developers who love Postgres. Guests join co-hosts Claire Giordano and Pino de Candia to discuss the human side of open source, databases, PostgreSQL, and the many PG extensions (including Citus.) Produced as a monthly live show on Discord by the Postgres team at Microsoft, subscribe to our calendar to join us live: https://aka.ms/PathToCitusCon-cal.

Path To Citus Con, for developers who love Postgres

mulander Nov 15, 2023

Claire Giordano ✨Nov 15, 2023

My boss wrote a blog post that just dropped announcing 11 new features in Azure Database for PostgreSQL - Flexible Server that are in GA & Public Preview including:
✅ #PostgreSQL 16 support (GA)
✅ Premium SSD v2 (Preview)
✅ New azure_ai extension (Preview)

For those of you who care about #PostgreSQL on Azure, details & links in Charles Feddersen's blog

#AzureDBPostgres #MSIgnite #Microsoft #Azure #Postgres

https://techcommunity.microsoft.com/t5/azure-database-for-postgresql/azure-database-for-postgresql-ai-ready-for-enterprise/ba-p/3980951

Azure%20Database%20for%20PostgreSQL%3A%20AI-Ready%20for%20Enterprise%20Applications%20in%20Flexible%20Server

Your guide to the 11 new features announced at Microsoft Ignite 2023 for Azure Database for PostgreSQL – Flexible Server, including the new azure_ai extension..

TECHCOMMUNITY.MICROSOFT.COM

mulander Sep 25, 2023

Claire Giordano ✨Sep 22, 2023

PostgreSQL 16 support has been added to Citus 12.1!

This blog post by Citus database engineer Naisila Puka walks through everything that's new in the 12.1 open source release of Citus. (There are some schema-based sharding improvements too...)

Good weekend reading. Big welcome to Citus 12.1. 👋 👋
#Citus #opensource #PostgreSQL #Postgres #database
https://www.citusdata.com/blog/2023/09/22/adding-postgres-16-support-to-citus-12-1/

Adding Postgres 16 support to Citus 12.1, plus schema-based sharding improvements

Postgres 16 is now supported by Citus! This post gives an overview of the 12.1 release of the Citus open source extension, with Postgres 16 support plus schema-based sharding improvements for multi-tenant SaaS apps (and microservices).

mulander Aug 16, 2023

Planet PostgreSQL (Unofficial)Aug 11, 2023

Carol Smith: Episode 6 highlights of Path To Citus Con podcast w/Chelsea Dole & Floor Drees https://www.citusdata.com/blog/2023/08/11/ep06-highlights-of-path-to-citus-con-podcast/
#postgres #postgresql

Episode 6 highlights of Path To Citus Con podcast w/Chelsea Dole & Floor Drees

Highlights & key moments from Ep06 of the Path To Citus Con podcast for developers who love Postgres, with guests Chelsea Dole & Floor Drees. This episode is geared toward app developers who are probably already using Postgres. Now what? What do you need to know?

mulander Aug 11, 2023

Claire Giordano ✨Aug 11, 2023

Hot off the press is Episode 6 of the #PathToCitusCon podcast for developers who love Postgres.

Live recording happened on Discord earlier this week & now it's available in all the podcast places 🎙️ so you can listen while you walk the dog or do dishes or _whatever_.

Thanks 🙌 to @floord & Chelsea Dole for joining Pino & me for the convo on "You're probably already using Postgres: What you need to know"

And +1 to Carol Smith & @asw for producing! #PostgreSQL #podcast https://pathtocituscon.transistor.fm/episodes/youre-probably-already-using-postgres-what-you-need-to-know-with-chelsea-dole-floor-drees

Path To Citus Con | You're probably already using Postgres: What you need to know with Chelsea Dole & Floor Drees

Path To Citus Con

mulander Aug 9, 2023

Claire Giordano ✨Aug 8, 2023

Do you like podcasts? Are you a developer? Do you love #PostgreSQL?

I'm co-hosting a new #podcast for developers who love Postgres

This Wed Aug 9 @ 10:00am PDT you can join the live recording of #PathToCitusCon Ep06 w/guests Chelsea Dole & @floord

Topic = You're probably already using Postgres: What you need to know

Boost please & tell friends

Mark your calendar (invite says how to join) https://aka.ms/PathToCitusCon-Ep06-cal

Or listen to past episodes anytime anywhere https://aka.ms/PathToCitusCon-transistor

Path To Citus Con: Episode 06

Mark your calendar for Path To Citus Con, a live show on Discord. Find us on the #cituscon channel in Discord @ https://aka.ms/open-source-discord. Guests for this episode are Chelsea Dole and Floor Drees.Episode 06: Wed Aug 9th @ 10:00am PDT – 11:00am PDT (UTC -7)Topic: You’re probably already using Postgres: What you need to knowOrganized by the Citus and Postgres team at Microsoft, this live show on Discord is an audio podcast with live text chat at the same time.

Show thread

mulander Jul 19, 2023

@manu @chrisisgr8 better update your card on file before that expiry date or you're in for a surprise during a family trip on the motorway! :)

Show thread

mulander Jul 19, 2023

@pamela and if you are short on cash, a normal wet towel will helps dogs greatly. Just soak it in cold water, fold in half and put it over the dog like a saddle on a horse. It's also good to have the dog lay down on it.

Show thread

mulander Jul 19, 2023

@chrisisgr8 the read-view-mirror camera feed will be available right after this 30 second clip from our sponsor!

mulander Jul 18, 2023

The 12.0 open-source release of the Citus database extension to #PostgreSQL is out!

Marco Slot in his post introduces schema-based sharding, goes into detail of sharding model tradeoffs, & even covers the extended PG MERGE support in this release:

https://www.citusdata.com/blog/2023/07/18/citus-12-schema-based-sharding-for-postgres/

Personally, I see this release as a major milestone for Citus. The list of changes may not be long, but actually introducing a whole new sharding model enables new types of workloads that were either very hard or near impossible to achieve with Citus.

While row-based sharding is still the most efficient both in terms of hardware margins (densely packing tenants on nodes) and performance - it did require a lot of up-front work to adapt schemas and apps to this model.

What types of apps had it hard?

One obvious app is actually regular multi-tenancy. The customer is always right, and sometimes your customers don't want to upgrade on the same pace as everyone else. There are also cases when some of them require individual schema changes.

With row based-sharding you share the schema, so individual touches like that are hard or impossible.

The second type of apps are #microservices, by definition they want to own the storage and handling storage in them is one of the main problems: https://stackoverflow.blog/2020/11/23/the-macro-problem-with-microservices/

Citus solves that now, with schema based sharding it's very easy to implement microservices: https://docs.citusdata.com/en/v12.0/get_started/tutorial_microservices.html

This allows easy horizontal scaling of storage, while giving these apps the autonomy they desire.

Best part however is: you can do both. Deploy with schema-based sharding and migrate parts of your app (or whale tenants) to the row-based sharding model.

All of this was developed 100% in the open. If you starred our GitHub repo, you saw it made live: https://github.com/citusdata/citus

Citus 12: Schema-based sharding for PostgreSQL

Release blog post for the 12.0 release of the Citus extension to Postgres. Dive into new Citus 12 features such as schema-based sharding for multi-tenant SaaS applications (and microservices) as well improvements in the Citus support for the Postgres 15 MERGE feature.