{"id":35405,"date":"2024-10-24T10:05:29","date_gmt":"2024-10-24T08:05:29","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/?p=35405"},"modified":"2025-03-04T11:03:44","modified_gmt":"2025-03-04T10:03:44","slug":"postgresql-conference-europe-2024-day-1","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/postgresql-conference-europe-2024-day-1\/","title":{"rendered":"PostgreSQL Conference Europe 2024 \u2013 Day 1"},"content":{"rendered":"\n

Attending PostgreSQL Conference Europe 2024 in Athens is an incredible experience, full of enriching conversations and technical deep dives. As a DBA Consultant and speaker (on the reserve list and honored to have been chosen), it was my first time meeting this amazing community in person and I was immediately struck by the camaraderie and shared passion for PostgreSQL.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

The atmosphere was welcoming, with everyone \u2014 from those just starting their PostgreSQL journey to seasoned veterans \u2014 eager to exchange knowledge. I even had the pleasure of meeting people whose blogs and posts I’ve followed for years, like Laurenz Albe. These interactions made me realize how vibrant and collaborative this community is.

The choices of talks to attend is quite tricky for me as I wanted to attend all of them.
You might want to check your self the schedule to get the idea :

Schedule \u2014 PostgreSQL Conference Europe 2024<\/a>
<\/p>\n\n\n\n

Sessions I Attended<\/h3>\n\n\n\n

Opening & Keynote: PostgreSQL and Licensing<\/strong>
The conference kicked off with a keynote that touched on the licensing structure of PostgreSQL. It was an insightful reminder of how PostgreSQL remains free and open-source, empowering countless organizations worldwide to run enterprise-grade databases without the burden of licensing fees and extending on the fact that the real fee was time and effort from the contributor and the community. <\/p>\n\n\n\n

Cybertec: High Concurrency & Distributed Snapshots<\/strong>
This session dived into Cybertec\u2019s research on improving high-concurrency workloads by implementing distributed snapshots. The idea of using a Commit Sequence Number system, similar to what Yugabyte uses with hybrid time, was particularly intriguing. I have to admit that I didn’t get most of the talk as this was part of the internal track but it was very interesting to see efforts being made by committers and the current on going improvement in making read and write IO capabilities even better. <\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Laurenz Albe: Security Attacks on PostgreSQL<\/strong>
Laurenz’s talk on security attacks was one of my most anticipated sessions. He covered practical techniques to defend against common security vulnerabilities in PostgreSQL. His advice on setting security_barrier = ON<\/code> for views, properly configuring security definer functions, and the potential abuse of search paths was invaluable. It reinforced how critical it is to consider these security measures when architecting secure PostgreSQL solutions. Myself I have a blog pending on this since some weeks now but the talk motivated me to publish it with some new ideas. <\/p>\n\n\n\n

Michael Bank: Patroni Deployment Patterns<\/strong>
As someone involved in high-availability setups, the session on Patroni deployment patterns by Michael Bank was a must-see. Michael explored various ways to implement Patroni in different environments, focusing on best practices and real-world examples. It provided a deeper understanding of how to fine-tune Patroni architectures in production environments, a topic that resonates with my ongoing work.<\/p>\n\n\n\n

<\/h3>\n\n\n\n

Social event <\/strong>
In the evening there was a social event where drinks and food were served and it was the occasion to meet even more people and speak all the languages you can…
It was the occasion for some to dress up : <\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n


The first day of the conference offered not only technical depth but also meaningful exchanges with fellow DBAs. The talks, combined with discussions, provided a perfect blend of learning and sharing.

Looking forward to what the rest of the conference holds !<\/p>\n\n\n\n

<\/p>\n","protected":false},"excerpt":{"rendered":"

Attending PostgreSQL Conference Europe 2024 in Athens is an incredible experience, full of enriching conversations and technical deep dives. As a DBA Consultant and speaker (on the reserve list and honored to have been chosen), it was my first time meeting this amazing community in person and I was immediately struck by the camaraderie and […]<\/p>\n","protected":false},"author":153,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[83],"tags":[3206,77],"type_dbi":[2749],"class_list":["post-35405","post","type-post","status-publish","format-standard","hentry","category-postgresql","tag-pgconf-eu","tag-postgresql","type-postgresql"],"acf":[],"yoast_head":"\nPostgreSQL Conference Europe 2024 \u2013 Day 1 - dbi Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/postgresql-conference-europe-2024-day-1\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"PostgreSQL Conference Europe 2024 \u2013 Day 1\" \/>\n<meta property=\"og:description\" content=\"Attending PostgreSQL Conference Europe 2024 in Athens is an incredible experience, full of enriching conversations and technical deep dives. As a DBA Consultant and speaker (on the reserve list and honored to have been chosen), it was my first time meeting this amazing community in person and I was immediately struck by the camaraderie and […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/postgresql-conference-europe-2024-day-1\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2024-10-24T08:05:29+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-03-04T10:03:44+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/10\/20241023_091748-scaled.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"2560\" \/>\n\t<meta property=\"og:image:height\" content=\"1920\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Adrien Obernesser\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Adrien Obernesser\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/postgresql-conference-europe-2024-day-1\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/postgresql-conference-europe-2024-day-1\/\"},\"author\":{\"name\":\"Adrien Obernesser\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/fd2ab917212ce0200c7618afaa7fdbcd\"},\"headline\":\"PostgreSQL Conference Europe 2024 \u2013 Day 1\",\"datePublished\":\"2024-10-24T08:05:29+00:00\",\"dateModified\":\"2025-03-04T10:03:44+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/postgresql-conference-europe-2024-day-1\/\"},\"wordCount\":544,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/postgresql-conference-europe-2024-day-1\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/10\/20241023_091748-1024x768.jpg\",\"keywords\":[\"pgconf.eu\",\"PostgreSQL\"],\"articleSection\":[\"PostgreSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/postgresql-conference-europe-2024-day-1\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/postgresql-conference-europe-2024-day-1\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/postgresql-conference-europe-2024-day-1\/\",\"name\":\"PostgreSQL Conference Europe 2024 \u2013 Day 1 - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/postgresql-conference-europe-2024-day-1\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/postgresql-conference-europe-2024-day-1\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/10\/20241023_091748-1024x768.jpg\",\"datePublished\":\"2024-10-24T08:05:29+00:00\",\"dateModified\":\"2025-03-04T10:03:44+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/fd2ab917212ce0200c7618afaa7fdbcd\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/postgresql-conference-europe-2024-day-1\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/postgresql-conference-europe-2024-day-1\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/postgresql-conference-europe-2024-day-1\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/10\/20241023_091748-scaled.jpg\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/10\/20241023_091748-scaled.jpg\",\"width\":2560,\"height\":1920},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/postgresql-conference-europe-2024-day-1\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"PostgreSQL Conference Europe 2024 \u2013 Day 1\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/fd2ab917212ce0200c7618afaa7fdbcd\",\"name\":\"Adrien Obernesser\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/dc9316c729e50107159e0a1e631b9c1742ce8898576887d0103c83b1ca3bc9e6?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/dc9316c729e50107159e0a1e631b9c1742ce8898576887d0103c83b1ca3bc9e6?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/dc9316c729e50107159e0a1e631b9c1742ce8898576887d0103c83b1ca3bc9e6?s=96&d=mm&r=g\",\"caption\":\"Adrien Obernesser\"},\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/adrienobernesser\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"PostgreSQL Conference Europe 2024 \u2013 Day 1 - dbi Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/postgresql-conference-europe-2024-day-1\/","og_locale":"en_US","og_type":"article","og_title":"PostgreSQL Conference Europe 2024 \u2013 Day 1","og_description":"Attending PostgreSQL Conference Europe 2024 in Athens is an incredible experience, full of enriching conversations and technical deep dives. As a DBA Consultant and speaker (on the reserve list and honored to have been chosen), it was my first time meeting this amazing community in person and I was immediately struck by the camaraderie and […]","og_url":"https:\/\/www.dbi-services.com\/blog\/postgresql-conference-europe-2024-day-1\/","og_site_name":"dbi Blog","article_published_time":"2024-10-24T08:05:29+00:00","article_modified_time":"2025-03-04T10:03:44+00:00","og_image":[{"width":2560,"height":1920,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/10\/20241023_091748-scaled.jpg","type":"image\/jpeg"}],"author":"Adrien Obernesser","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Adrien Obernesser","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/postgresql-conference-europe-2024-day-1\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/postgresql-conference-europe-2024-day-1\/"},"author":{"name":"Adrien Obernesser","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/fd2ab917212ce0200c7618afaa7fdbcd"},"headline":"PostgreSQL Conference Europe 2024 \u2013 Day 1","datePublished":"2024-10-24T08:05:29+00:00","dateModified":"2025-03-04T10:03:44+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/postgresql-conference-europe-2024-day-1\/"},"wordCount":544,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/postgresql-conference-europe-2024-day-1\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/10\/20241023_091748-1024x768.jpg","keywords":["pgconf.eu","PostgreSQL"],"articleSection":["PostgreSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/postgresql-conference-europe-2024-day-1\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/postgresql-conference-europe-2024-day-1\/","url":"https:\/\/www.dbi-services.com\/blog\/postgresql-conference-europe-2024-day-1\/","name":"PostgreSQL Conference Europe 2024 \u2013 Day 1 - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/postgresql-conference-europe-2024-day-1\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/postgresql-conference-europe-2024-day-1\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/10\/20241023_091748-1024x768.jpg","datePublished":"2024-10-24T08:05:29+00:00","dateModified":"2025-03-04T10:03:44+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/fd2ab917212ce0200c7618afaa7fdbcd"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/postgresql-conference-europe-2024-day-1\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/postgresql-conference-europe-2024-day-1\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/postgresql-conference-europe-2024-day-1\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/10\/20241023_091748-scaled.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/10\/20241023_091748-scaled.jpg","width":2560,"height":1920},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/postgresql-conference-europe-2024-day-1\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"PostgreSQL Conference Europe 2024 \u2013 Day 1"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/fd2ab917212ce0200c7618afaa7fdbcd","name":"Adrien Obernesser","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/dc9316c729e50107159e0a1e631b9c1742ce8898576887d0103c83b1ca3bc9e6?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/dc9316c729e50107159e0a1e631b9c1742ce8898576887d0103c83b1ca3bc9e6?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/dc9316c729e50107159e0a1e631b9c1742ce8898576887d0103c83b1ca3bc9e6?s=96&d=mm&r=g","caption":"Adrien Obernesser"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/adrienobernesser\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/35405","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/153"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=35405"}],"version-history":[{"count":6,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/35405\/revisions"}],"predecessor-version":[{"id":35415,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/35405\/revisions\/35415"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=35405"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=35405"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=35405"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=35405"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}