Prague PostgreSQL Dev DayPostgreSQL 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
Data BeneThe 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 🍿
EDBPGConf EU is kicking of next week. Across the schedule, EDB engineers, advocates, and organizers are shaping conversations that stretch from community health to AI architectures, from accessibility to observability. Together, their work traces how Postgres keeps expanding its meaning, not just its feature set: https://www.enterprisedb.com/blog/many-futures-postgres-edb-pgconfeu-2025 #PostgreSQL #pg18
pgEdge PostgresLooking 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
One of the headlining features of PostgreSQL 18 is virtual generated columns, which our Chief Architect Peter Eisentraut worked on. He tells the engaging story of that feature on the EDB blog: https://www.enterprisedb.com/blog/journey-virtual-generated-columns #PostgreSQL #PG18 @petereisentraut
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
PostgreSQL 18 ships with support for OAuth 2.0. Jacob Champion, Principal Software Engineer at EDB, posted the first proof-of-concept for this feature back in 2021. He shares the journey (and some spicy opinions) on the blog: https://www.enterprisedb.com/blog/developing-oauth #PostgreSQL #authentication #pg18
We're very excited for #PG18, just released!
Ahsan Hadi wrote about some notable features released within #PostgreSQL 18 that we're excited about here at pgEdge, such as the ability to add an asynchronous I/O subsystem to boost database I/O performance (especially for sequential scans, bitmap heap scans, & VACUUM operations).
Two more blogs to come in this series. In the meantime, what features are *you* most excited for?
Jeroen Habets#PostgreSQL 18 new #async io already seems to yield signficant #performance gains even in its first iteration:
https://www.cybertec-postgresql.com/en/postgresql-18-better-i-o-performance-with-aio/
