Kejau Touray

Want to attend the conference and enhance your PostgreSQL knowledge at the same time? In addition to conference talks, you can attend full- or half-day world-class PostgreSQL training sessions carefully selected by our Programme Committee! These sessions are held on Tuesday, ahead of the conference, and can be purchased as part of your registration. The number of places is limited. - Mastering PostgreSQL in Kubernetes with CloudNativePG - Hands-on Introduction to PostgreSQL Operation - Logical replication - getting in and out of the cloud - A beginner's guide to performance - Are you collecting the right metrics? - Empowering AI Applications: Integrating Vector Databases with PostgreSQL Register: https://lnkd.in/dQKcT5eF #postgresql #postgres #training #workshop

46

With the improvements in logical replication released in PostgreSQL 16, there is an increasing interest in active-active clusters in PostgreSQL. Attendees at PostgreSQL Conference Europe this year packed the conference room for EDB Manager, Solutions Architects Boriss Mejías’s talk on Active-Active PostgreSQL. In this informative session, Boriss drew an insightful comparison between Sparta’s Dual Kingship and PostgreSQL Active-Active. With a few clever jokes mixed in, the audience laughed and learned how the illusion of a transparent active-active cluster is broken when you’re facing the challenges of having multiple writable database nodes. Boriss walked the audience through the possibilities and challenges of a PostgreSQL cluster when multiple writable nodes collaborate to a common goal, and explained how lessons from classical Greek government systems can be applied to these situations. Watch Boriss's full talk here: https://bit.ly/3V2ryHr #EDBPostgresAI #JustSolveItWithPostgres #PostgreSQL #OpenSource #DataInfrastructure #Postgres #PGConf #PGConfEU #PGConfAthens

20

Doltgres now supports importing tab-formatted data using the COPY FROM STDIN statement. Today's blog by Jason Fulghum explains how PostgreSQL's wire protocol supports fast and efficient data imports with the COPY FROM STDIN statement, and demos our support in Doltgres. https://lnkd.in/eEFMPEdQ

6

Here’s our latest blog post on What’s New in PostgreSQL 17: Essential Updates for DBAs and Developers https://lnkd.in/daZch-E5

5

Fantastic DZone article published today by our very own Ahsan Hadi entitled, "PostgreSQL 17: A Major Step Forward in Performance." Check in out: https://hubs.la/Q02V769d0 #pgedge #dzone #PostgreSQL @postgresqlprofessionals #postgresql17

12

Becoming more involved in the PostgreSQL community is as simple as becoming a member of PgUS! Join us today! https://buff.ly/3czbR3G #PostgreSQL #postgres

3

Becoming more involved in the PostgreSQL community is as simple as becoming a member of PgUS! Join us today! https://buff.ly/3czbR3G #PostgreSQL #postgres

2

September Community Sync is live on YouTube! Many exciting highlights were covered this month such as: 🔍 Added support for running SQL on Daft and updated documentation with SQL code examples 📝 Completed support for partitioned writes for Iceberg & Delta Lake tables 📈 Latest progress on Swordfish has shown DuckDB-like local performance Watch it here: https://lnkd.in/gETGtVhe The next Daft Contributor Sync will be on Thursday, October 31 🎃 Make sure to add it to your calendar! https://lnkd.in/gvP64vfR #Daft #DataFrame #ContributorSync #SQL #Iceberg #DeltaLake

2

ARTICLE ON THE VALUE OF Apache Iceberg CATALOGS https://lnkd.in/e-tN8g6J #DataLake #DataLakehouse #ApacheIceberg #Nessie #ApachePolaris #DataEngineering

15

💡 Want to enhance your #AzureCosmosDB for NoSQL setup? Learn how to change partition keys to better align with your data access patterns. 🛠️ Check out the guide: https://lnkd.in/dsDPHVmR

3

One of our amazing engineers, Louise Grandjonc Leinweber, was at PostgreSQL Conference Europe in October and presented a talk on Postgres statistics tables. Louise's talk is a really in-depth and comprehensive overview of how Postgres collects statistics and then uses those in query plans and decisions later. The recording is now available. This talk is a really deep dive into the Postgres back end - but with a lot of practical tips that affect your application and database queries. Put this one on your watch list for December. https://lnkd.in/g4r5duSb

41

1 Comment

Considering coming to the PostgreSQL Conference Europe in Athens this October? You might be interested in attending Ilya's training, which will take place on Tuesday before the conference begins. This practical tutorial will guide you through the complete process of PostgreSQL installation, providing the necessary skills to operate PostgreSQL in a realistic production environment. You will start by installing and configuring PostgreSQL on Linux. Followed by performing of tuning based on the resources of the VM and exploring useful system views. After that, we will set up and learn how to operate pgBouncer. Then, we will configure backup and recovery infrastructure using pgBackRest and set up a physical replica. The final step will take you through a major upgrade process using the pg_upgrade tool. Read more: https://lnkd.in/e8n_3mbr

13