#postgresql18 — Public Fediverse posts
Live and recent posts from across the Fediverse tagged #postgresql18, aggregated by home.social.
-
FORMATION : ajouts de TP, correctifs et revue des cours en intégrant les nouveautés de #PostgreSQL18… les manuels Dalibo viennent d'être mis à jour => https://dali.bo/202605_manuels
Toujours en accès libre sous format html, pdf, ePub, et slides. 👀
Merci à nos collègues #DBA pour leur travail ! 💐
-
FORMATION : ajouts de TP, correctifs et revue des cours en intégrant les nouveautés de #PostgreSQL18… les manuels Dalibo viennent d'être mis à jour => https://dali.bo/202605_manuels
Toujours en accès libre sous format html, pdf, ePub, et slides. 👀
Merci à nos collègues #DBA pour leur travail ! 💐
-
FORMATION : ajouts de TP, correctifs et revue des cours en intégrant les nouveautés de #PostgreSQL18… les manuels Dalibo viennent d'être mis à jour => https://dali.bo/202605_manuels
Toujours en accès libre sous format html, pdf, ePub, et slides. 👀
Merci à nos collègues #DBA pour leur travail ! 💐
-
FORMATION : ajouts de TP, correctifs et revue des cours en intégrant les nouveautés de #PostgreSQL18… les manuels Dalibo viennent d'être mis à jour => https://dali.bo/202605_manuels
Toujours en accès libre sous format html, pdf, ePub, et slides. 👀
Merci à nos collègues #DBA pour leur travail ! 💐
-
FORMATION : ajouts de TP, correctifs et revue des cours en intégrant les nouveautés de #PostgreSQL18… les manuels Dalibo viennent d'être mis à jour => https://dali.bo/202605_manuels
Toujours en accès libre sous format html, pdf, ePub, et slides. 👀
Merci à nos collègues #DBA pour leur travail ! 💐
-
PostgreSQL 18 saute la case imprimeur.
La 6e édition du livre "PostgreSQL — Architecture et notions avancées" (Guillaume Lelarge & Julien Rouhaud) paraît aujourd'hui en numérique, sur les traces de la version 18.
Pour les irréductibles du papier, la 5e édition (PostgreSQL 16) reste une valeur sûre.
-
PostgreSQL 18 saute la case imprimeur.
La 6e édition du livre "PostgreSQL — Architecture et notions avancées" (Guillaume Lelarge & Julien Rouhaud) paraît aujourd'hui en numérique, sur les traces de la version 18.
Pour les irréductibles du papier, la 5e édition (PostgreSQL 16) reste une valeur sûre.
-
PostgreSQL 18 saute la case imprimeur.
La 6e édition du livre "PostgreSQL — Architecture et notions avancées" (Guillaume Lelarge & Julien Rouhaud) paraît aujourd'hui en numérique, sur les traces de la version 18.
Pour les irréductibles du papier, la 5e édition (PostgreSQL 16) reste une valeur sûre.
-
PostgreSQL 18 saute la case imprimeur.
La 6e édition du livre "PostgreSQL — Architecture et notions avancées" (Guillaume Lelarge & Julien Rouhaud) paraît aujourd'hui en numérique, sur les traces de la version 18.
Pour les irréductibles du papier, la 5e édition (PostgreSQL 16) reste une valeur sûre.
-
PostgreSQL 18 saute la case imprimeur.
La 6e édition du livre "PostgreSQL — Architecture et notions avancées" (Guillaume Lelarge & Julien Rouhaud) paraît aujourd'hui en numérique, sur les traces de la version 18.
Pour les irréductibles du papier, la 5e édition (PostgreSQL 16) reste une valeur sûre.
-
Des nouveautés de #PostgreSQL18 à la sécurisation des données, en passant par les statistiques et #Kubernetes… 🐘
Les #conférences de la #pgsession18 auront lieu demain à Paris, mais comment y participer à distance ?
Voici le programme **à jour** et les liens utiles : https://dali.bo/202601_pgsession18_distance
-
#PostgreSQL 18's new improvements simplify complex workflows, reduce round trips to the database, & make building modern apps more efficient than ever.
Our newest blog is focused on:
→ What's new in RETURNING clause functionality
→ Real-world use cases and performance benefits
→ How to leverage these enhancements in your applicationsPerfect for devs & database architects looking to maximize PG18's capabilities.
Check it out: https://www.pgedge.com/blog/postgresql-18-returning-enhancements-a-game-changer-for-modern-applications
-
Instant database clones with PostgreSQL 18 via @boringsql.
-
🚀 Oh joy, PostgreSQL 18 now has "instant" clones, because who doesn't love watching their #database pretend to be a Xerox machine? 🤦♂️ Just remember, it's as thrilling as watching paint dry—but now with benchmarks and #XFS proofs! 😂
https://boringsql.com/posts/instant-database-clones/ #PostgreSQL18 #instantclones #Xeroxmachine #techupdates #databaseperformance #HackerNews #ngated -
🚀 Oh joy, PostgreSQL 18 now has "instant" clones, because who doesn't love watching their #database pretend to be a Xerox machine? 🤦♂️ Just remember, it's as thrilling as watching paint dry—but now with benchmarks and #XFS proofs! 😂
https://boringsql.com/posts/instant-database-clones/ #PostgreSQL18 #instantclones #Xeroxmachine #techupdates #databaseperformance #HackerNews #ngated -
🚀 Oh joy, PostgreSQL 18 now has "instant" clones, because who doesn't love watching their #database pretend to be a Xerox machine? 🤦♂️ Just remember, it's as thrilling as watching paint dry—but now with benchmarks and #XFS proofs! 😂
https://boringsql.com/posts/instant-database-clones/ #PostgreSQL18 #instantclones #Xeroxmachine #techupdates #databaseperformance #HackerNews #ngated -
🚀 Oh joy, PostgreSQL 18 now has "instant" clones, because who doesn't love watching their #database pretend to be a Xerox machine? 🤦♂️ Just remember, it's as thrilling as watching paint dry—but now with benchmarks and #XFS proofs! 😂
https://boringsql.com/posts/instant-database-clones/ #PostgreSQL18 #instantclones #Xeroxmachine #techupdates #databaseperformance #HackerNews #ngated -
Instant database clones with PostgreSQL 18
https://boringsql.com/posts/instant-database-clones/
#HackerNews #InstantDatabaseClones #PostgreSQL18 #DatabaseManagement #TechNews #BoringSQL
-
Instant database clones with PostgreSQL 18
https://boringsql.com/posts/instant-database-clones/
#HackerNews #InstantDatabaseClones #PostgreSQL18 #DatabaseManagement #TechNews #BoringSQL
-
Instant database clones with PostgreSQL 18
https://boringsql.com/posts/instant-database-clones/
#HackerNews #InstantDatabaseClones #PostgreSQL18 #DatabaseManagement #TechNews #BoringSQL
-
Instant database clones with PostgreSQL 18
https://boringsql.com/posts/instant-database-clones/
#HackerNews #InstantDatabaseClones #PostgreSQL18 #DatabaseManagement #TechNews #BoringSQL
-
Instant database clones with PostgreSQL 18
https://boringsql.com/posts/instant-database-clones/
#HackerNews #InstantDatabaseClones #PostgreSQL18 #DatabaseManagement #TechNews #BoringSQL
-
Neuer Blogpost: PostgreSQL 18 führt asynchrone Festplatten-E/A ein.
Wir geben einen detaillierten Einblick in die Implementierung und die technischen Hintergründe. -
Aparentemente se les fue la olla a los de #Fedora con la actualización a #Fedora43 si se tiene instalado #PostgreSQL.
#Fedora42 trae #PostgreSQL_16, mientras que la v43 trae #PostgreSQL_18. Entonces, al actualizar el SO, todo peta, porque no puedes usar `postgresql-setup --upgrade`, ya que tu cluster es v16 y el upgrade sólo sirve de v17 a v18.
Más info y solución, aquí: https://discussion.fedoraproject.org/t/cant-upgrade-postgres-after-f42-f43/171071/4
-
Exploring PostgreSQL 18's new UUIDv7 support
https://aiven.io/blog/exploring-postgresql-18-new-uuidv7-support
#HackerNews #PostgreSQL #UUIDv7 #UUIDs #DatabaseTech #PostgreSQL18 #AivenBlog
-
#PostgreSQL18 permettra d'optimiser encore plus les requêtes.
Guillaume aborde une fonctionnalité introduite par la version 9.0 et améliorée depuis la semaine dernière : la **suppression de jointures inutiles**. -
#postgres 18 will support #OAuth2—exciting! My use case: editing #geodata in #QGIS with #PostGIS. Most #orgs use single-sign-on #sso , but #PostGIS editing still requires separate passwords. OAuth2 could simplify this process
#postgresql #postgresql18
https://www.crunchydata.com/blog/get-excited-about-postgres-18#oauth-20 -
🚀🎉 Wow, groundbreaking revelation! PostgreSQL 18 can multitask like a teenager texting, eating, and ignoring chores simultaneously. Who knew #pipelining was the secret sauce to sending queries faster than your cat ignoring you? 🐱📚
https://postgresql.verite.pro/blog/2025/10/01/psql-pipeline.html #PostgreSQL18 #multitasking #database #innovation #technology #HackerNews #ngated -
🚀🎉 Wow, groundbreaking revelation! PostgreSQL 18 can multitask like a teenager texting, eating, and ignoring chores simultaneously. Who knew #pipelining was the secret sauce to sending queries faster than your cat ignoring you? 🐱📚
https://postgresql.verite.pro/blog/2025/10/01/psql-pipeline.html #PostgreSQL18 #multitasking #database #innovation #technology #HackerNews #ngated -
🚀🎉 Wow, groundbreaking revelation! PostgreSQL 18 can multitask like a teenager texting, eating, and ignoring chores simultaneously. Who knew #pipelining was the secret sauce to sending queries faster than your cat ignoring you? 🐱📚
https://postgresql.verite.pro/blog/2025/10/01/psql-pipeline.html #PostgreSQL18 #multitasking #database #innovation #technology #HackerNews #ngated -
🚀🎉 Wow, groundbreaking revelation! PostgreSQL 18 can multitask like a teenager texting, eating, and ignoring chores simultaneously. Who knew #pipelining was the secret sauce to sending queries faster than your cat ignoring you? 🐱📚
https://postgresql.verite.pro/blog/2025/10/01/psql-pipeline.html #PostgreSQL18 #multitasking #database #innovation #technology #HackerNews #ngated -
🚀🎉 Wow, groundbreaking revelation! PostgreSQL 18 can multitask like a teenager texting, eating, and ignoring chores simultaneously. Who knew #pipelining was the secret sauce to sending queries faster than your cat ignoring you? 🐱📚
https://postgresql.verite.pro/blog/2025/10/01/psql-pipeline.html #PostgreSQL18 #multitasking #database #innovation #technology #HackerNews #ngated -
#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
-
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
-
🎉🎩 Ah, PostgreSQL 18: the version where we finally get excited about asynchronous IO, as if databases haven’t been doing it for decades. But don't worry, no details or benchmarks here, just a riveting suggestion to watch a talk from 2025. 🌟🔮
https://vondra.me/posts/tuning-aio-in-postgresql-18/ #PostgreSQL18 #AsynchronousIO #DatabaseTalks #FutureTech #HackerNews #ngated -
#PostgreSQL18 brings major changes to the statistics ecosystem, like:
✨ pg_upgrade retains the optimizer stats (a welcome change!)
✨ Statistics I/O in bytes instead of pages
✨ New C API for extensions
✨ I/O visibility by backend with pg_stat_get_backend_io()
✨ Better insights for conflict managementNotably, you can now use the #PostgreSQL Cumulative Statistics API. Export, import and adjust stats at will.
Learn more in our latest blog from @c2main https://www.data-bene.io/en/blog/cumulative-statistics-in-postgresql-18
-
Upgrading from PostgreSQL v17 to v18. 🚀 Using the
pg_upgradeclustercommand if you want to know.Just be sure you have enough RAM memory & storage left during such an upgrade. If needed increase your huge pages numbers (in case you enabled huge pages). 🤞 #postgresql #postgresql18 #upgrade #server
https://www.postgresql.org/about/news/postgresql-18-released-3142/
-
RE: https://mastodon.social/@pgEdgeDistributedPostgres/115142577862912902
#PostgreSQL18 coming out next week - have you taken a look at new and upcoming features yet?
-
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 🔎
-
🔍 Want full-text search in any language with #postgresql18
Watch Vee Satayamas present a powerful extension that breaks language barriers—bringing advanced search to multilingual applications with ease.
🎥 Click here: https://youtu.be/C6o71HQXTaQ
-
Où l'on aborde la clause RETURNING, qui permet de récupérer des informations sur les lignes de table insérées, modifiées ou supprimées. Cette fonctionnalité a été améliorée dans #PostgreSQL18
=> https://dali.bo/202501_returning -
#PostgreSQL 17 est à peine sortie que nos collègues sont déjà à l'affut des nouveautés de la v.18. 🧐
Cette dernière supporte désormais la clause WITHOUT OVERLAPS de la norme ISO #SQL, et Denis vous explique comment elle va faciliter l'écriture de certaines contraintes =>
https://dali.bo/202410_contraintes_temporelles -
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
-
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
-
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
-
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
-
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
-
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