#citus — Public Fediverse posts

🎙️ New #TalkingPostgres #podcast Ep37 is out!

Charles Feddersen, partner director of product for Postgres on Azure, joined me to talk about building Postgres services on Azure, his views on PM work, & his transition to Postgres 🐘 which started when he was building classic ASP apps with Microsoft Access back in Melbourne (back in the early 2000s). Lots of miles in between and all in the database space. It was fun!

🎧 https://talkingpostgres.com/episodes/building-postgres-services-on-azure-with-charles-feddersen
📺 https://youtu.be/L_2kyfL9LN0?si=6o5oKZj414Bv1wbP

#PostgreSQL #Postgres #databases #Azure #Citus #PGConfdev #Microsoft #Product

We have PostgreSQL 14 on Debian 11 with TimescaleDB 2.16.1.
We want PostgreSQL 18 on Debian 13 with TimescaleDB 2.23.1.

But the support of TimescaleDB on PostgreSQL 14 ends at version 2.19.3.

On Debian 13 and PostgreSQL 18, the minimum version of TimescaleDB available is 2.23.0.

We have to upgrade with an intermediary step:

1. Upgrade TimescaleDB to 2.19.3 in-place
2. Upgrade to PostgreSQL 17 on Debian 12 (with TimescaleDB 2.19.3)
3. Upgrade TimescaleDB to 2.23.1
4. Upgrade to PostgreSQL 18 on Debian 13 (with TimescaleDB 2.23.1).

Add a multi-terabytes of data making dump/restore impossible.

At least the extension is available on Debian 13 which is not the case of age and Citus.

This is nice to have a 5 years support on PostgreSQL but beware if you use extensions. The time window could be less than that, complicating the upgrade process.

#postgresql #timescaledb #age #citus #upgrade #debian

Khám phá Phần 3 xây dựng hạ tầng SaaS: Citus Database Performance – khi sharding giúp và khi gây hại. Bài viết phân tích khi nào phân vùng dữ liệu thực sự tăng hiệu suất, khi nào lại khiến truy vấn chậm và tăng chi phí. Các lưu ý: phù hợp với read‑heavy workloads, tránh sharding khi write‑bound hoặc dữ liệu liền kề. Bạn muốn tối ưu Citus? Đọc ngay nhé!
#SaaS #Citus #Sharding #CơSởDữLiệu #DatabaseOptimization

https://www.reddit.com/r/SaaS/comments/1p6rpq3/part_3_saas_infrastructure_buildout_ci

Shardman и Citus: как масштабировать СУБД Postgres Pro

Когда ресурсы сервера уже на пределе, вертикальное масштабирование рано или поздно перестаёт работать — остаётся горизонтальный подход. В этой статье подробно разбираем два способа шардирования в Postgres Pro: встроенный патч Shardman и внешнее расширение Citus. Сравним архитектуры, межузловое взаимодействие, схемы распределения данных и сценарии, в которых каждое решение раскрывается по‑максимуму.

https://habr.com/ru/companies/postgrespro/articles/932572/

#масштабирование #shardman #citus #отказоустойчивость #шардирование

#Postgres Café: Deploying distributed #PostgreSQL at scale with #Citus Data https://www.data-bene.io/en/blog/postgres-cafe-deploying-distributed-postgresql-at-scale-with-citus-data/ #podcast

Шардированный не значит распределённый: что важно знать, когда PostgreSQL становится мало

Шардирование, двухфазный коммит и распределенные транзакции окружены определенными мифами и заблуждениями. Например, может быть достаточно неочевидно, что двухфазный коммит обеспечивает только атомарность транзакций, но не их изоляцию. Поэтому мы решили написать пост, который бы помог разобраться в этих сложных вещах и сделать правильный выбор, когда Postgres'а Вам станет мало и Вы столкнётесь с шардированием.

https://habr.com/ru/companies/ydb/articles/907024/

#субд #postgres #postgresql #citus #sharding #distributed #ydb #dbms #consistency #acid

Шардированный не значит распределённый: что важно знать, когда PostgreSQL становится мало

Шардирование, двухфазный коммит и распределенные транзакции окружены определенными мифами и заблуждениями. Например, может быть достаточно неочевидно, что двухфазный коммит обеспечивает только атомарность транзакций, но не их изоляцию. Поэтому мы решили написать пост, который бы помог разобраться в этих сложных вещах и сделать правильный выбор, когда Postgres'а Вам станет мало и Вы столкнётесь с шардированием.

https://habr.com/ru/companies/ydb/articles/907024/

#субд #postgres #postgresql #citus #sharding #distributed #ydb #dbms #consistency #acid

Шардированный не значит распределённый: что важно знать, когда PostgreSQL становится мало

Шардирование, двухфазный коммит и распределенные транзакции окружены определенными мифами и заблуждениями. Например, может быть достаточно неочевидно, что двухфазный коммит обеспечивает только атомарность транзакций, но не их изоляцию. Поэтому мы решили написать пост, который бы помог разобраться в этих сложных вещах и сделать правильный выбор, когда Postgres'а Вам станет мало и Вы столкнётесь с шардированием.

https://habr.com/ru/companies/ydb/articles/907024/

#субд #postgres #postgresql #citus #sharding #distributed #ydb #dbms #consistency #acid

Шардированный не значит распределённый: что важно знать, когда PostgreSQL становится мало

Шардирование, двухфазный коммит и распределенные транзакции окружены определенными мифами и заблуждениями. Например, может быть достаточно неочевидно, что двухфазный коммит обеспечивает только атомарность транзакций, но не их изоляцию. Поэтому мы решили написать пост, который бы помог разобраться в этих сложных вещах и сделать правильный выбор, когда Postgres'а Вам станет мало и Вы столкнётесь с шардированием.

https://habr.com/ru/companies/ydb/articles/907024/

#субд #postgres #postgresql #citus #sharding #distributed #ydb #dbms #consistency #acid

📼 Recording today!

“SaaS on Rails on PostgreSQL”

Attend this free online event, to be streamed with live Q&A on June 11! Hope you can attend. 😊

https://www.citusdata.com/posette/speakers/andrew-atkinson/

#Posette #RubyOnRails #PostgreSQL #Postgres The Pragmatic Programmers #Citus #Conference

Как и почему мы построили Единую историю операций на Citus DB

Доступ к единой истории операций — функция, которую сегодня ожидают видеть пользователи любого современного интернет-банкинга. В приложениях Газпромбанка функция существует уже много лет, но некоторое время назад мы решили существенно её переработать. В этой статье я расскажу, что мы поменяли, как и почему мы решили это сделать, а также почему мы гордимся результатом. Сразу оговорюсь, что не буду углубляться в технические детали и остановлюсь на подходе, который мы решили использовать. Иначе есть риск что статья превратится в километровое полотнище. А если возникнут вопросы, то либо отвечу на них в комментах, либо аккумулирую и попробую разобрать в следующей статье.

https://habr.com/ru/companies/gazprombank/articles/810477/

#citus #базы #шардирование #базы_данных

Enjoyed collaborating with Postgres & PgBouncer engineer Emel Simsek who works in the PG team at Microsoft, on her first-ever blog post, published on the Citus Open Source Blog

... about the new support in PgBouncer 1.20.0 for Session vars

(#PgBouncer is one of the more popular connection poolers for #PostgreSQL)
#database #Citus #OpenSource #Microsoft

Enjoy! https://www.citusdata.com/blog/2024/04/04/pgbouncer-supports-more-session-vars/

Today at #pgconfeu I shared as many pics as I could of the amazing #PostgreSQL speakers—but I haven’t yet shared one of myself!

My talk in Prague was a “Beginners Guide to Partitioning vs Sharding in Postgres” & it was so much fun! Thank you to all of you who attended 👏👏👏
#OpenSource #database #community #oartitioning #sharding #Citus

Today at #pgconfeu I shared as many pics as I could of the amazing #PostgreSQL speakers—but I haven’t yet shared one of myself!

My talk in Prague was a “Beginners Guide to Partitioning vs Sharding in Postgres” & it was so much fun! Thank you to all of you who attended 👏👏👏
#OpenSource #database #community #oartitioning #sharding #Citus

Today at #pgconfeu I shared as many pics as I could of the amazing #PostgreSQL speakers—but I haven’t yet shared one of myself!

My talk in Prague was a “Beginners Guide to Partitioning vs Sharding in Postgres” & it was so much fun! Thank you to all of you who attended 👏👏👏
#OpenSource #database #community #oartitioning #sharding #Citus

Today at #pgconfeu I shared as many pics as I could of the amazing #PostgreSQL speakers—but I haven’t yet shared one of myself!

My talk in Prague was a “Beginners Guide to Partitioning vs Sharding in Postgres” & it was so much fun! Thank you to all of you who attended 👏👏👏
#OpenSource #database #community #oartitioning #sharding #Citus

Today at #pgconfeu I shared as many pics as I could of the amazing #PostgreSQL speakers—but I haven’t yet shared one of myself!

My talk in Prague was a “Beginners Guide to Partitioning vs Sharding in Postgres” & it was so much fun! Thank you to all of you who attended 👏👏👏
#OpenSource #database #community #oartitioning #sharding #Citus

Why People Care About PostGIS And Postgres With Paul Ramsey & Regina Obe [podcast]
--
https://pathtocituscon.transistor.fm/episodes/why-people-care-about-postgis-and-postgres-with-paul-ramsey-regina-obe <-- link to podcast and overview
--
https://youtu.be/nVg-z36m_pw?si=CCm9vEtnrxOUFfvM <-- YouTube audio link
--
#GIS #spatial #mapping #postgis #postgresql #postgres #podcast #extension #opensource #largelanguagemodles #model #modeling #pgrouting #universalforeignkey #openstreetmap #foss4g #mobilitydb #citus #osgeo #ogc #llm ##fedgeoday #gischat

Why People Care About PostGIS And Postgres With Paul Ramsey & Regina Obe [podcast]
--
https://pathtocituscon.transistor.fm/episodes/why-people-care-about-postgis-and-postgres-with-paul-ramsey-regina-obe <-- link to podcast and overview
--
https://youtu.be/nVg-z36m_pw?si=CCm9vEtnrxOUFfvM <-- YouTube audio link
--
#GIS #spatial #mapping #postgis #postgresql #postgres #podcast #extension #opensource #largelanguagemodles #model #modeling #pgrouting #universalforeignkey #openstreetmap #foss4g #mobilitydb #citus #osgeo #ogc #llm ##fedgeoday #gischat

Why People Care About PostGIS And Postgres With Paul Ramsey & Regina Obe [podcast]
--
https://pathtocituscon.transistor.fm/episodes/why-people-care-about-postgis-and-postgres-with-paul-ramsey-regina-obe <-- link to podcast and overview
--
https://youtu.be/nVg-z36m_pw?si=CCm9vEtnrxOUFfvM <-- YouTube audio link
--
#GIS #spatial #mapping #postgis #postgresql #postgres #podcast #extension #opensource #largelanguagemodles #model #modeling #pgrouting #universalforeignkey #openstreetmap #foss4g #mobilitydb #citus #osgeo #ogc #llm ##fedgeoday #gischat

Why People Care About PostGIS And Postgres With Paul Ramsey & Regina Obe [podcast]
--
https://pathtocituscon.transistor.fm/episodes/why-people-care-about-postgis-and-postgres-with-paul-ramsey-regina-obe <-- link to podcast and overview
--
https://youtu.be/nVg-z36m_pw?si=CCm9vEtnrxOUFfvM <-- YouTube audio link
--
#GIS #spatial #mapping #postgis #postgresql #postgres #podcast #extension #opensource #largelanguagemodles #model #modeling #pgrouting #universalforeignkey #openstreetmap #foss4g #mobilitydb #citus #osgeo #ogc #llm ##fedgeoday #gischat

Why People Care About PostGIS And Postgres With Paul Ramsey & Regina Obe [podcast]
--
https://pathtocituscon.transistor.fm/episodes/why-people-care-about-postgis-and-postgres-with-paul-ramsey-regina-obe <-- link to podcast and overview
--
https://youtu.be/nVg-z36m_pw?si=CCm9vEtnrxOUFfvM <-- YouTube audio link
--
#GIS #spatial #mapping #postgis #postgresql #postgres #podcast #extension #opensource #largelanguagemodles #model #modeling #pgrouting #universalforeignkey #openstreetmap #foss4g #mobilitydb #citus #osgeo #ogc #llm ##fedgeoday #gischat

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

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

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

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

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/

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

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

Live Release party going over #Citus 11.3 happening now -- #postgres devs looking to see some advanced new features with Citus.

#parrallel shard rebalancing
#MERGE support
#Patroni HA
#Tennant Monitoring

https://www.youtube.com/live/ihgr_QEX6IU?feature=share

As co-chair, I'm excited about this 💥 all the individual livestream talks from Citus Con: An Event for Postgres 2023 have published on YouTube 📺

Including some phenomenal talks 💡 by @simon & @cyberdemn & @tmunro - and others not yet on Mastodon

Enjoy the playlist of 37 talks & pls tell your friends

https://aka.ms/cituscon-playlist

#CitusCon #PostgreSQL #Citus #SmallData #OpenSource #Patroni #YouTube #DistributedPostgreSQL #HammerDB

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

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

The #CFP is *open* for Citus Con: An Event for Postgres 2023. 📣

We're looking for talk proposals about #PostgreSQL, or the Citus database extension, or other PG extensions, or Azure managed database services like #AzureDBPostgres & #AzureCosmosDB for PostgreSQL.

After answering the question "Why give a conference talk?" a bunch of times, I wrote this post. ✍️ Enjoy! (Boosts are appreciated. 🙌 )

#CallForSpeakers #CitusCon #Citus
https://www.citusdata.com/blog/2022/01/11/why-give-a-conference-talk/

Hot off the press, new first-ever blog post from Ozan Saka, an engineer on the Citus database team, about:

* How we made Postgres 15 support generally available in Azure Cosmos DB for PostgreSQL within just 1 week of the PG15 release!

One of the many benefits of Citus being an extension to PostgreSQL is that it's easier to keep it current with the latest Postgres releases!

#Citus #PostgreSQL #Azure #AzureCosmosDB

https://www.citusdata.com/blog/2022/11/29/enabling-postgresql-15-in-azure-cosmos-db-for-postgresql-how-we-did-it/

After having a look at #cockroachdb and #yugabyte database licenses, I find surprised that CockroachDB backtracked and it's now closed software.

But anyway, these two seem both oriented at selling it as a service, not really #foss. Or at least my impression.

There is market for a totally distributed cloud alike #PostgreSQL. And it is doable because at least there are two products out there. #citus seems to be lacking multimaster, and not sure if integrates with #BDR