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 applications
Perfect 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
PostgreSQL 18 has arrived with some fantastic improvements, and among them, the RETURNING clause enhancements stand out as a feature that every PostgreSQL developer and DBA should be excited about. In this blog, I'll explore these enhancements, with particular focus on the MERGE RETURNING clause enhancement, and demonstrate how they can simplify your application architecture and improve data tracking capabilities.
Instant database clones with PostgreSQL 18 via @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
Unfortunately there are a few issues. Fedora does not allow to install multiple versions of Postgres, which makes this a bit more complicated. Luckily the postgres-upgrade packages include the “old” (n-1) binaries. There are a few options available how to do the upgrade. I am trying to find a nice solution that is the least error prone. e.g. if you are not careful you might end up with things like old cluster does not use data checksums but the new one does. An upgrade always replaces your c...
Exploring PostgreSQL 18's new UUIDv7 support
https://aiven.io/blog/exploring-postgresql-18-new-uuidv7-support
#HackerNews #PostgreSQL #UUIDv7 #UUIDs #DatabaseTech #PostgreSQL18 #AivenBlog
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
Dalibo
pgEdge Postgres
joschi
N-gated Hacker News
Hacker News
credativ GmbH
Carl von Lesquereux