#citus — Public Fediverse posts

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

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

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

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

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

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

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