#pg18 — Public Fediverse posts
Live and recent posts from across the Fediverse tagged #pg18, aggregated by home.social.
-
PostgreSQL 18 brings big upgrades to constraints! 🔒
Gülçin Yıldırım Jelínek breaks down what’s new—from temporal PK/FKs to NOT ENFORCED constraints and better partition support—and how to use them in real systems. https://lnkd.in/d_xZ6HD2
-
The team is here at #PostgresIbiza, with Cat delivering a keynote on sustainable energy practices, Cédric discussing the new cumulative stats system in #PG18, Evan introducing a new #OpenSource extension our team is developing - more to come on this! - and Frédéric discussing transaction isolation levels in #PostgreSQL.
Wish you could watch? Follow to keep an eye out for video content from our team on these subjects, & so many more 🍿
-
Looking for an open-source, versatile database engine (or thinking about upgrading an existing instance)?
#PostgreSQL is a great solution; it's recommended to upgrade to the latest major version - 1 to ensure stability, and PG17 is a powerful release that brought major improvements to performance, logical replication, & more.
Read about it: https://www.pgedge.com/blog/postgresql-17-a-major-step-forward-in-performance-logical-replication-and-more
#pg18 #postgresql18 #postgres #programming #code #developer #devops #dba #datascience #database #foss #oss #opensource #tech
-
Now that #PostgreSQL18 has been released, it's a great time to learn about and experiment with #PostgreSQL Cumulative Statistics - an excellent feature that gives extension developers support for defining new statistics.
Learn more about stats (similar to what's in pg_stat* views & functions) and how to define your own views & functions in the future from @c2main:
https://mirrors.dotsrc.org/fosdem/2025/ua2220/fosdem-2025-4496-stats-roll-baby-stats-roll-.mp4@fosdem #FOSDEM2025 #postgres #programming #coding #tech #developer #sql #data #learning #pg18 #statistics
-
#PostgreSQL18 transforme le sous-système de statistiques. Exemples:
✨ Statistiques I/O en octets au lieu de pages
✨ Nouvelle API C pour les extensions
✨ Visibilité I/O par backend avec pg_stat_get_backend_io()La vraie nouveauté pour les développeurs d'extensions: vous pouvez maintenant utiliser l'API de statistiques cumulatives de #PostgreSQL. Exportez, importez et ajustez les stats à volonté.
https://www.data-bene.io/fr/blog/statistiques-cumulatives-dans-postgresql-18
#programmation #developpeur #technologie #Postgres #pg18 #informatique
-
As part of our upcoming Perspectives on PostgreSQL 18 series, Floor Drees sat down with Bruce Momjian and Tom Kincaid to talk about the role of community in every release.
In this clip, Bruce explains why open source works like a democracy and why a healthy project is like a magnifying glass that amplifies the impact of every contributor 🔎