{"id":9167,"date":"2025-07-04T15:10:56","date_gmt":"2025-07-04T13:10:56","guid":{"rendered":"https:\/\/www.credativ.de\/?p=9167"},"modified":"2025-07-04T15:10:56","modified_gmt":"2025-07-04T13:10:56","slug":"swiss-postgresql-day-2025","status":"publish","type":"post","link":"https:\/\/www.credativ.de\/en\/blog\/postgresql-en\/swiss-postgresql-day-2025\/","title":{"rendered":"Swiss PostgreSQL Day 2025"},"content":{"rendered":"<p>On Thursday, 26 June and Friday, 27 June 2025, my colleague Patrick Lauer and I had the amazing opportunity to attend <a href=\"https:\/\/www.pgday.ch\/2025\/#home\">Swiss PGDay 2025<\/a>, held at the OST Eastern Switzerland University of Applied Sciences in Rapperswil. This two-day PostgreSQL conference featured two parallel tracks of presentations in English and German, bringing together users and experts primarily from across Switzerland. Our company, credativ, was among the supporters of this year&#8217;s conference.<\/p>\n<p>During the event, Patrick delivered an engaging session titled \u201c<strong>Postgres with many data: To MAXINT and beyond<\/strong>,\u201d which built on past discussions about massive-scale Postgres usage. He highlighted the practical issues that arise when handling extremely large datasets in PostgreSQL \u2013 for instance, how even a simple SELECT COUNT(*) can become painfully slow, and how backups and restores can take days on very large datasets. He also shared strategies to manage performance effectively at these scales.<\/p>\n<p>I presented a significantly updated version of my talk, \u201c<strong>Building a Data Lakehouse with PostgreSQL: Dive into Formats, Tools, Techniques, and Strategies<\/strong>.\u201d It covered modern data formats and frameworks such as Apache Iceberg, addressing key challenges in lakehouse architectures \u2013 from governance, privacy, and compliance, to data quality checks and AI\/ML use cases. The talk emphasized PostgreSQL&#8217;s capability to play a central role in today&#8217;s data lakehouse and AI landscape. At the close of the conference, I delivered a brief lightning talk showcasing our new open-source migration tool, \u201ccredativ-pg-migrator.\u201d<\/p>\n<p><a href=\"https:\/\/www.credativ.de\/wp-content\/uploads\/2025\/07\/1751364359267.jpeg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-9171\" src=\"https:\/\/www.credativ.de\/wp-content\/uploads\/2025\/07\/1751364359267-225x300.jpeg\" alt=\"\" width=\"225\" height=\"300\" srcset=\"https:\/\/www.credativ.de\/wp-content\/uploads\/2025\/07\/1751364359267-225x300.jpeg 225w, https:\/\/www.credativ.de\/wp-content\/uploads\/2025\/07\/1751364359267-768x1024.jpeg 768w, https:\/\/www.credativ.de\/wp-content\/uploads\/2025\/07\/1751364359267-600x800.jpeg 600w, https:\/\/www.credativ.de\/wp-content\/uploads\/2025\/07\/1751364359267-180x240.jpeg 180w, https:\/\/www.credativ.de\/wp-content\/uploads\/2025\/07\/1751364359267.jpeg 960w\" sizes=\"auto, (max-width: 225px) 100vw, 225px\" \/><\/a>\u00a0 <a href=\"https:\/\/www.credativ.de\/wp-content\/uploads\/2025\/07\/1751364393173.jpeg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-9173\" src=\"https:\/\/www.credativ.de\/wp-content\/uploads\/2025\/07\/1751364393173-225x300.jpeg\" alt=\"\" width=\"225\" height=\"300\" srcset=\"https:\/\/www.credativ.de\/wp-content\/uploads\/2025\/07\/1751364393173-225x300.jpeg 225w, https:\/\/www.credativ.de\/wp-content\/uploads\/2025\/07\/1751364393173-768x1024.jpeg 768w, https:\/\/www.credativ.de\/wp-content\/uploads\/2025\/07\/1751364393173-600x800.jpeg 600w, https:\/\/www.credativ.de\/wp-content\/uploads\/2025\/07\/1751364393173-180x240.jpeg 180w, https:\/\/www.credativ.de\/wp-content\/uploads\/2025\/07\/1751364393173.jpeg 960w\" sizes=\"auto, (max-width: 225px) 100vw, 225px\" \/><\/a><br \/>\n(c) photos by G\u00fcl\u00e7in Y\u0131ld\u0131r\u0131m Jelinek<\/p>\n<p>The <a href=\"https:\/\/www.pgday.ch\/2025\/#schedule\">conference schedule<\/a> was packed with many high-quality, insightful talks. We would particularly like to highlight:<\/p>\n<p>* <strong>Bruce Momjian \u2013 \u201cHow Open Source and Democracy Drive Postgres\u201d<\/strong>: In his keynote, Bruce Momjian outlined how PostgreSQL\u2019s open-source development model and democratic governance have powered its success. He explained the differences between open-source and proprietary models, reviewed PostgreSQL\u2019s governance history, and illustrated how democratic, open processes result in robust software and a promising future for Postgres.<\/p>\n<p>* <strong>G\u00fcl\u00e7in Y\u0131ld\u0131r\u0131m Jelinek \u2013 \u201cAnatomy of Table-Level Locks in PostgreSQL\u201d<\/strong>: session covered the fundamentals of PostgreSQL\u2019s table-level locking mechanisms. Explained how different lock modes are acquired and queued during schema changes, helping attendees understand how to manage lock conflicts, minimize downtime, and avoid deadlocks during high-concurrency DDL operations.<\/p>\n<p>* <strong>Aarno Aukia \u2013 \u201cOperating PostgreSQL at Scale: Lessons from Hundreds of Instances in Regulated Private Clouds\u201d<\/strong>: the speaker shared lessons from running extensive Postgres environments in highly regulated industries. He discussed architectural patterns, automation strategies, and &#8220;day-2 operations&#8221; practices that VSHN uses to meet stringent availability, compliance, and audit requirements, including secure multi-tenancy, declarative deployments, backups, monitoring, and lifecycle management in mission-critical cloud-native setups.<\/p>\n<p>* <strong>Bertrand Hartwig-Peillon \u2013 \u201cpgAssistant\u201d<\/strong>: Author introduced pgAssistant, an open-source tool designed to help developers optimize PostgreSQL schemas and queries before production deployment. He demonstrated how pgAssistant combines deterministic analysis with an AI-driven approach to detect schema inconsistencies and suggest optimizations, effectively automating best practices and performance tuning within development workflows.<\/p>\n<p>* <strong>Gianni Ciolli \u2013 \u201cThe Why and What of WAL\u201d<\/strong>: Gianni Ciolli provided in a great Italian style concise history and overview of PostgreSQL\u2019s Write-Ahead Log (WAL). He explained WAL\u2019s central role in PostgreSQL for crash safety, backups, and replication, showcasing examples of WAL-enabled features like fast crash recovery, efficient hot backups, physical replication, and logical decoding.<\/p>\n<p>* <strong>Daniel Krefl \u2013 \u201cHacking pgvector for performance\u201d<\/strong>: The speaker presented an enhanced version of the pgvector extension for massive data processing, optimized by maintaining the vector index outside PostgreSQL memory and offloading computations, including GPU integration. He detailed the process of moving pgvector\u2019s core logic externally for improved speed, demonstrating notable performance gains in the EU AERO project context. He also talked about distributed PostgreSQL XC, XL and TBase, which are unfortunately stuck on the old version 10 and how he ported changes from these projects into the version 16.<\/p>\n<p>* <strong>Luigi Nardi \u2013 \u201cA benchmark study on the impact of PostgreSQL server parameter tuning\u201d<\/strong>: Luigi Nardi presented comprehensive benchmark results on tuning PostgreSQL configuration parameters. Highlighting that many users default settings, he demonstrated how significant performance improvements can be achieved through proper tuning across various workloads (OLTP, OLAP, etc.), providing actionable insights tailored to specific environments.<\/p>\n<p>* <strong>Renzo Dani \u2013 \u201cFrom Oracle to PostgreSQL: A HARD Journey and an Open-Source Awakening\u201d<\/strong>: Author recounted his experiences migrating a complex enterprise application from Oracle to PostgreSQL, addressing significant challenges such as implicit type casting, function overloading differences, JDBC driver issues, and SQL validation problems. He also highlighted the benefits, including faster CI pipelines, more flexible deployments, and innovation opportunities provided by open-source Postgres, along with practical advice on migration tools, testing strategies, and managing trade-offs.<\/p>\n<p><a href=\"https:\/\/www.credativ.de\/wp-content\/uploads\/2025\/07\/IMG_8151_small-scaled.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-9178\" src=\"https:\/\/www.credativ.de\/wp-content\/uploads\/2025\/07\/IMG_8151_small-300x225.jpg\" alt=\"\" width=\"300\" height=\"225\" srcset=\"https:\/\/www.credativ.de\/wp-content\/uploads\/2025\/07\/IMG_8151_small-300x225.jpg 300w, https:\/\/www.credativ.de\/wp-content\/uploads\/2025\/07\/IMG_8151_small-1024x768.jpg 1024w, https:\/\/www.credativ.de\/wp-content\/uploads\/2025\/07\/IMG_8151_small-768x576.jpg 768w, https:\/\/www.credativ.de\/wp-content\/uploads\/2025\/07\/IMG_8151_small-1536x1152.jpg 1536w, https:\/\/www.credativ.de\/wp-content\/uploads\/2025\/07\/IMG_8151_small-2048x1536.jpg 2048w, https:\/\/www.credativ.de\/wp-content\/uploads\/2025\/07\/IMG_8151_small-600x450.jpg 600w, https:\/\/www.credativ.de\/wp-content\/uploads\/2025\/07\/IMG_8151_small-180x135.jpg 180w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><br \/>\n(c) photo by Swiss PostgreSQL User Group<\/p>\n<p>At the end of the first day, all participants enjoyed a networking dinner. We both want to sincerely thank the Swiss PGDay organizers (Swiss PostgreSQL User Group) for an amazing event. Swiss PGDay 2025 was a memorable and valuable experience, offering great learning and networking opportunities. We are also very grateful to credativ for enabling our participation, and we look forward to future editions of this excellent conference.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>On Thursday, 26 June and Friday, 27 June 2025, my colleague Patrick Lauer and I had the amazing opportunity to attend Swiss PGDay 2025, held at the OST Eastern Switzerland University of Applied Sciences in Rapperswil. This two-day PostgreSQL conference featured two parallel tracks of presentations in English and German, bringing together users and experts [&hellip;]<\/p>\n","protected":false},"author":82,"featured_media":9171,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_improvement_type_select":"improve_an_existing","_thumb_yes_seoaic":false,"_frame_yes_seoaic":false,"seoaic_generate_description":"","seoaic_improve_instructions_prompt":"","seoaic_rollback_content_improvement":"","seoaic_idea_thumbnail_generator":"","thumbnail_generated":false,"thumbnail_generate_prompt":"","seoaic_article_description":"","seoaic_article_subtitles":[],"footnotes":""},"categories":[1703,1708],"tags":[1907,1801],"class_list":["post-9167","post","type-post","status-publish","format-standard","hentry","category-news","category-postgresql-en","tag-conference","tag-postgresql-en"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.3 (Yoast SEO v27.3) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Swiss PostgreSQL Day 2025 - credativ\u00ae<\/title>\n<meta name=\"description\" content=\"Swiss PostgreSQL Day 2025 is a highlight for database enthusiasts. Discover the best moments of the event.\" \/>\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.credativ.de\/en\/blog\/postgresql-en\/swiss-postgresql-day-2025\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Swiss PostgreSQL Day 2025\" \/>\n<meta property=\"og:description\" content=\"Swiss PostgreSQL Day 2025 is a highlight for database enthusiasts. Discover the best moments of the event.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.credativ.de\/en\/blog\/postgresql-en\/swiss-postgresql-day-2025\/\" \/>\n<meta property=\"og:site_name\" content=\"credativ\u00ae\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/credativDE\/\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-04T13:10:56+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.credativ.de\/wp-content\/uploads\/2025\/07\/1751364359267.jpeg\" \/>\n\t<meta property=\"og:image:width\" content=\"960\" \/>\n\t<meta property=\"og:image:height\" content=\"1280\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Josef Machytka\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@credativde\" \/>\n<meta name=\"twitter:site\" content=\"@credativde\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Josef Machytka\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.credativ.de\\\/en\\\/blog\\\/postgresql-en\\\/swiss-postgresql-day-2025\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.credativ.de\\\/en\\\/blog\\\/postgresql-en\\\/swiss-postgresql-day-2025\\\/\"},\"author\":{\"name\":\"Josef Machytka\",\"@id\":\"https:\\\/\\\/www.credativ.de\\\/en\\\/#\\\/schema\\\/person\\\/b5f03833b09ed0acd1c8d3307d05bd1a\"},\"headline\":\"Swiss PostgreSQL Day 2025\",\"datePublished\":\"2025-07-04T13:10:56+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.credativ.de\\\/en\\\/blog\\\/postgresql-en\\\/swiss-postgresql-day-2025\\\/\"},\"wordCount\":835,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.credativ.de\\\/en\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.credativ.de\\\/en\\\/blog\\\/postgresql-en\\\/swiss-postgresql-day-2025\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.credativ.de\\\/wp-content\\\/uploads\\\/2025\\\/07\\\/1751364359267.jpeg\",\"keywords\":[\"Conference\",\"PostgreSQL\u00ae\"],\"articleSection\":[\"News\",\"PostgreSQL\u00ae\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.credativ.de\\\/en\\\/blog\\\/postgresql-en\\\/swiss-postgresql-day-2025\\\/#respond\"]}],\"copyrightYear\":\"2025\",\"copyrightHolder\":{\"@id\":\"https:\\\/\\\/www.credativ.de\\\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.credativ.de\\\/en\\\/blog\\\/postgresql-en\\\/swiss-postgresql-day-2025\\\/\",\"url\":\"https:\\\/\\\/www.credativ.de\\\/en\\\/blog\\\/postgresql-en\\\/swiss-postgresql-day-2025\\\/\",\"name\":\"Swiss PostgreSQL Day 2025 - credativ\u00ae\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.credativ.de\\\/en\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.credativ.de\\\/en\\\/blog\\\/postgresql-en\\\/swiss-postgresql-day-2025\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.credativ.de\\\/en\\\/blog\\\/postgresql-en\\\/swiss-postgresql-day-2025\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.credativ.de\\\/wp-content\\\/uploads\\\/2025\\\/07\\\/1751364359267.jpeg\",\"datePublished\":\"2025-07-04T13:10:56+00:00\",\"description\":\"Swiss PostgreSQL Day 2025 is a highlight for database enthusiasts. Discover the best moments of the event.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.credativ.de\\\/en\\\/blog\\\/postgresql-en\\\/swiss-postgresql-day-2025\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.credativ.de\\\/en\\\/blog\\\/postgresql-en\\\/swiss-postgresql-day-2025\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.credativ.de\\\/en\\\/blog\\\/postgresql-en\\\/swiss-postgresql-day-2025\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.credativ.de\\\/wp-content\\\/uploads\\\/2025\\\/07\\\/1751364359267.jpeg\",\"contentUrl\":\"https:\\\/\\\/www.credativ.de\\\/wp-content\\\/uploads\\\/2025\\\/07\\\/1751364359267.jpeg\",\"width\":960,\"height\":1280},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.credativ.de\\\/en\\\/blog\\\/postgresql-en\\\/swiss-postgresql-day-2025\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.credativ.de\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Swiss PostgreSQL Day 2025\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.credativ.de\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/www.credativ.de\\\/en\\\/\",\"name\":\"credativ GmbH\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.credativ.de\\\/en\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.credativ.de\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Organization\",\"Place\"],\"@id\":\"https:\\\/\\\/www.credativ.de\\\/en\\\/#organization\",\"name\":\"credativ\u00ae\",\"url\":\"https:\\\/\\\/www.credativ.de\\\/en\\\/\",\"logo\":{\"@id\":\"https:\\\/\\\/www.credativ.de\\\/en\\\/blog\\\/postgresql-en\\\/swiss-postgresql-day-2025\\\/#local-main-organization-logo\"},\"image\":{\"@id\":\"https:\\\/\\\/www.credativ.de\\\/en\\\/blog\\\/postgresql-en\\\/swiss-postgresql-day-2025\\\/#local-main-organization-logo\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/credativDE\\\/\",\"https:\\\/\\\/x.com\\\/credativde\",\"https:\\\/\\\/mastodon.social\\\/@credativde\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/credativ-gmbh\",\"https:\\\/\\\/www.instagram.com\\\/credativ\\\/\"],\"description\":\"Die credativ GmbH ist ein f\u00fchrendes, auf Open Source Software spezialisiertes IT-Dienstleistungs- und Beratungsunternehmen. Wir bieten umfassende und professionelle Services, von Beratung und Infrastruktur-Betrieb \u00fcber 24\\\/7 Support bis hin zu individuellen L\u00f6sungen und Schulungen. Unser Fokus liegt auf dem ganzheitlichen Management von gesch\u00e4ftskritischen Open-Source-Systemen, darunter Betriebssysteme (z.B. Linux), Datenbanken (z.B. PostgreSQL), Konfigurationsmanagement (z.B. Ansible, Puppet) und Virtualisierung. Als engagierter Teil der Open-Source-Community unterst\u00fctzen wir unsere Kunden dabei, die Vorteile freier Software sicher, stabil und effizient in ihrer IT-Umgebung zu nutzen.\",\"legalName\":\"credativ GmbH\",\"foundingDate\":\"2025-03-01\",\"duns\":\"316387060\",\"numberOfEmployees\":{\"@type\":\"QuantitativeValue\",\"minValue\":\"11\",\"maxValue\":\"50\"},\"address\":{\"@id\":\"https:\\\/\\\/www.credativ.de\\\/en\\\/blog\\\/postgresql-en\\\/swiss-postgresql-day-2025\\\/#local-main-place-address\"},\"geo\":{\"@type\":\"GeoCoordinates\",\"latitude\":\"51.1732374\",\"longitude\":\"6.392010099999999\"},\"telephone\":[\"+4921619174200\",\"08002733284\"],\"contactPoint\":{\"@type\":\"ContactPoint\",\"telephone\":\"08002733284\",\"email\":\"vertrieb@credativ.de\"},\"openingHoursSpecification\":[{\"@type\":\"OpeningHoursSpecification\",\"dayOfWeek\":[\"Monday\",\"Tuesday\",\"Wednesday\",\"Thursday\",\"Friday\"],\"opens\":\"09:00\",\"closes\":\"17:00\"},{\"@type\":\"OpeningHoursSpecification\",\"dayOfWeek\":[\"Saturday\",\"Sunday\"],\"opens\":\"00:00\",\"closes\":\"00:00\"}],\"email\":\"info@credativ.de\",\"areaServed\":\"D-A-CH\",\"vatID\":\"DE452151696\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.credativ.de\\\/en\\\/#\\\/schema\\\/person\\\/b5f03833b09ed0acd1c8d3307d05bd1a\",\"name\":\"Josef Machytka\"},{\"@type\":\"PostalAddress\",\"@id\":\"https:\\\/\\\/www.credativ.de\\\/en\\\/blog\\\/postgresql-en\\\/swiss-postgresql-day-2025\\\/#local-main-place-address\",\"streetAddress\":\"Hennes-Weisweiler-Allee 23\",\"addressLocality\":\"M\u00f6nchengladbach\",\"postalCode\":\"41179\",\"addressRegion\":\"Deutschland\",\"addressCountry\":\"DE\"},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.credativ.de\\\/en\\\/blog\\\/postgresql-en\\\/swiss-postgresql-day-2025\\\/#local-main-organization-logo\",\"url\":\"https:\\\/\\\/www.credativ.de\\\/wp-content\\\/uploads\\\/2025\\\/04\\\/credativ-logo-right.svg\",\"contentUrl\":\"https:\\\/\\\/www.credativ.de\\\/wp-content\\\/uploads\\\/2025\\\/04\\\/credativ-logo-right.svg\",\"caption\":\"credativ\u00ae\"}]}<\/script>\n<meta name=\"geo.placename\" content=\"M\u00f6nchengladbach\" \/>\n<meta name=\"geo.position\" content=\"51.1732374;6.392010099999999\" \/>\n<meta name=\"geo.region\" content=\"Germany\" \/>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Swiss PostgreSQL Day 2025 - credativ\u00ae","description":"Swiss PostgreSQL Day 2025 is a highlight for database enthusiasts. Discover the best moments of the event.","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.credativ.de\/en\/blog\/postgresql-en\/swiss-postgresql-day-2025\/","og_locale":"en_US","og_type":"article","og_title":"Swiss PostgreSQL Day 2025","og_description":"Swiss PostgreSQL Day 2025 is a highlight for database enthusiasts. Discover the best moments of the event.","og_url":"https:\/\/www.credativ.de\/en\/blog\/postgresql-en\/swiss-postgresql-day-2025\/","og_site_name":"credativ\u00ae","article_publisher":"https:\/\/www.facebook.com\/credativDE\/","article_published_time":"2025-07-04T13:10:56+00:00","og_image":[{"width":960,"height":1280,"url":"https:\/\/www.credativ.de\/wp-content\/uploads\/2025\/07\/1751364359267.jpeg","type":"image\/jpeg"}],"author":"Josef Machytka","twitter_card":"summary_large_image","twitter_creator":"@credativde","twitter_site":"@credativde","twitter_misc":{"Written by":"Josef Machytka","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.credativ.de\/en\/blog\/postgresql-en\/swiss-postgresql-day-2025\/#article","isPartOf":{"@id":"https:\/\/www.credativ.de\/en\/blog\/postgresql-en\/swiss-postgresql-day-2025\/"},"author":{"name":"Josef Machytka","@id":"https:\/\/www.credativ.de\/en\/#\/schema\/person\/b5f03833b09ed0acd1c8d3307d05bd1a"},"headline":"Swiss PostgreSQL Day 2025","datePublished":"2025-07-04T13:10:56+00:00","mainEntityOfPage":{"@id":"https:\/\/www.credativ.de\/en\/blog\/postgresql-en\/swiss-postgresql-day-2025\/"},"wordCount":835,"commentCount":0,"publisher":{"@id":"https:\/\/www.credativ.de\/en\/#organization"},"image":{"@id":"https:\/\/www.credativ.de\/en\/blog\/postgresql-en\/swiss-postgresql-day-2025\/#primaryimage"},"thumbnailUrl":"https:\/\/www.credativ.de\/wp-content\/uploads\/2025\/07\/1751364359267.jpeg","keywords":["Conference","PostgreSQL\u00ae"],"articleSection":["News","PostgreSQL\u00ae"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.credativ.de\/en\/blog\/postgresql-en\/swiss-postgresql-day-2025\/#respond"]}],"copyrightYear":"2025","copyrightHolder":{"@id":"https:\/\/www.credativ.de\/#organization"}},{"@type":"WebPage","@id":"https:\/\/www.credativ.de\/en\/blog\/postgresql-en\/swiss-postgresql-day-2025\/","url":"https:\/\/www.credativ.de\/en\/blog\/postgresql-en\/swiss-postgresql-day-2025\/","name":"Swiss PostgreSQL Day 2025 - credativ\u00ae","isPartOf":{"@id":"https:\/\/www.credativ.de\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.credativ.de\/en\/blog\/postgresql-en\/swiss-postgresql-day-2025\/#primaryimage"},"image":{"@id":"https:\/\/www.credativ.de\/en\/blog\/postgresql-en\/swiss-postgresql-day-2025\/#primaryimage"},"thumbnailUrl":"https:\/\/www.credativ.de\/wp-content\/uploads\/2025\/07\/1751364359267.jpeg","datePublished":"2025-07-04T13:10:56+00:00","description":"Swiss PostgreSQL Day 2025 is a highlight for database enthusiasts. Discover the best moments of the event.","breadcrumb":{"@id":"https:\/\/www.credativ.de\/en\/blog\/postgresql-en\/swiss-postgresql-day-2025\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.credativ.de\/en\/blog\/postgresql-en\/swiss-postgresql-day-2025\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.credativ.de\/en\/blog\/postgresql-en\/swiss-postgresql-day-2025\/#primaryimage","url":"https:\/\/www.credativ.de\/wp-content\/uploads\/2025\/07\/1751364359267.jpeg","contentUrl":"https:\/\/www.credativ.de\/wp-content\/uploads\/2025\/07\/1751364359267.jpeg","width":960,"height":1280},{"@type":"BreadcrumbList","@id":"https:\/\/www.credativ.de\/en\/blog\/postgresql-en\/swiss-postgresql-day-2025\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.credativ.de\/en\/"},{"@type":"ListItem","position":2,"name":"Swiss PostgreSQL Day 2025"}]},{"@type":"WebSite","@id":"https:\/\/www.credativ.de\/en\/#website","url":"https:\/\/www.credativ.de\/en\/","name":"credativ GmbH","description":"","publisher":{"@id":"https:\/\/www.credativ.de\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.credativ.de\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Organization","Place"],"@id":"https:\/\/www.credativ.de\/en\/#organization","name":"credativ\u00ae","url":"https:\/\/www.credativ.de\/en\/","logo":{"@id":"https:\/\/www.credativ.de\/en\/blog\/postgresql-en\/swiss-postgresql-day-2025\/#local-main-organization-logo"},"image":{"@id":"https:\/\/www.credativ.de\/en\/blog\/postgresql-en\/swiss-postgresql-day-2025\/#local-main-organization-logo"},"sameAs":["https:\/\/www.facebook.com\/credativDE\/","https:\/\/x.com\/credativde","https:\/\/mastodon.social\/@credativde","https:\/\/www.linkedin.com\/company\/credativ-gmbh","https:\/\/www.instagram.com\/credativ\/"],"description":"Die credativ GmbH ist ein f\u00fchrendes, auf Open Source Software spezialisiertes IT-Dienstleistungs- und Beratungsunternehmen. Wir bieten umfassende und professionelle Services, von Beratung und Infrastruktur-Betrieb \u00fcber 24\/7 Support bis hin zu individuellen L\u00f6sungen und Schulungen. Unser Fokus liegt auf dem ganzheitlichen Management von gesch\u00e4ftskritischen Open-Source-Systemen, darunter Betriebssysteme (z.B. Linux), Datenbanken (z.B. PostgreSQL), Konfigurationsmanagement (z.B. Ansible, Puppet) und Virtualisierung. Als engagierter Teil der Open-Source-Community unterst\u00fctzen wir unsere Kunden dabei, die Vorteile freier Software sicher, stabil und effizient in ihrer IT-Umgebung zu nutzen.","legalName":"credativ GmbH","foundingDate":"2025-03-01","duns":"316387060","numberOfEmployees":{"@type":"QuantitativeValue","minValue":"11","maxValue":"50"},"address":{"@id":"https:\/\/www.credativ.de\/en\/blog\/postgresql-en\/swiss-postgresql-day-2025\/#local-main-place-address"},"geo":{"@type":"GeoCoordinates","latitude":"51.1732374","longitude":"6.392010099999999"},"telephone":["+4921619174200","08002733284"],"contactPoint":{"@type":"ContactPoint","telephone":"08002733284","email":"vertrieb@credativ.de"},"openingHoursSpecification":[{"@type":"OpeningHoursSpecification","dayOfWeek":["Monday","Tuesday","Wednesday","Thursday","Friday"],"opens":"09:00","closes":"17:00"},{"@type":"OpeningHoursSpecification","dayOfWeek":["Saturday","Sunday"],"opens":"00:00","closes":"00:00"}],"email":"info@credativ.de","areaServed":"D-A-CH","vatID":"DE452151696"},{"@type":"Person","@id":"https:\/\/www.credativ.de\/en\/#\/schema\/person\/b5f03833b09ed0acd1c8d3307d05bd1a","name":"Josef Machytka"},{"@type":"PostalAddress","@id":"https:\/\/www.credativ.de\/en\/blog\/postgresql-en\/swiss-postgresql-day-2025\/#local-main-place-address","streetAddress":"Hennes-Weisweiler-Allee 23","addressLocality":"M\u00f6nchengladbach","postalCode":"41179","addressRegion":"Deutschland","addressCountry":"DE"},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.credativ.de\/en\/blog\/postgresql-en\/swiss-postgresql-day-2025\/#local-main-organization-logo","url":"https:\/\/www.credativ.de\/wp-content\/uploads\/2025\/04\/credativ-logo-right.svg","contentUrl":"https:\/\/www.credativ.de\/wp-content\/uploads\/2025\/04\/credativ-logo-right.svg","caption":"credativ\u00ae"}]},"geo.placename":"M\u00f6nchengladbach","geo.position":{"lat":"51.1732374","long":"6.392010099999999"},"geo.region":"Germany"},"_links":{"self":[{"href":"https:\/\/www.credativ.de\/en\/wp-json\/wp\/v2\/posts\/9167","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.credativ.de\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.credativ.de\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.credativ.de\/en\/wp-json\/wp\/v2\/users\/82"}],"replies":[{"embeddable":true,"href":"https:\/\/www.credativ.de\/en\/wp-json\/wp\/v2\/comments?post=9167"}],"version-history":[{"count":8,"href":"https:\/\/www.credativ.de\/en\/wp-json\/wp\/v2\/posts\/9167\/revisions"}],"predecessor-version":[{"id":9182,"href":"https:\/\/www.credativ.de\/en\/wp-json\/wp\/v2\/posts\/9167\/revisions\/9182"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.credativ.de\/en\/wp-json\/wp\/v2\/media\/9171"}],"wp:attachment":[{"href":"https:\/\/www.credativ.de\/en\/wp-json\/wp\/v2\/media?parent=9167"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.credativ.de\/en\/wp-json\/wp\/v2\/categories?post=9167"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.credativ.de\/en\/wp-json\/wp\/v2\/tags?post=9167"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}