{"id":48142,"date":"2026-10-26T22:23:07","date_gmt":"2026-10-26T21:23:07","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/?p=48142"},"modified":"2026-10-26T22:23:07","modified_gmt":"2026-10-26T21:23:07","slug":"pgconf-eu-2026-day-2-3","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/pgconf-eu-2026-day-2-3\/","title":{"rendered":"PGConf.EU 2026 \u2013 Day 2 &amp; 3"},"content":{"rendered":"\n<h2 id=\"h-vacuum-and-autovacuum\" class=\"wp-block-heading\">Vacuum and autovacuum<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">I started the second day of PGConf.EU with a session about vacuum and autovacuum, presented by Teresa Lopes.<br>After a short introduction to how MVCC works, she presented the different elements related to autovacuum:<br>What are the different phases of autovacuum? What can trigger autovacuum? Which parameters can influence autovacuum? All these points were explained in a simple and clear way during the presentation.<br>Teresa also presented several reasons why autovacuum might not start, including a long-running transaction, an abandoned replication slot or an abandoned prepared transaction.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The second half of the presentation focused on new autovacuum features in PostgreSQL 19, for example:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>The scoring system for autovacuum, based on criteria such as XID\/MXID age and the number of inserted, updated or deleted tuples.<\/li>\n\n\n\n<li>The possibility to use parallel workers for index vacuuming and cleanup.<\/li>\n\n\n\n<li>Improved ways to observe and monitor autovacuum, especially through new views and new logging parameters.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">The session ended with a look at how to recover disk space in tables after autovacuum has cleaned them up, especially with <code><a href=\"https:\/\/www.postgresql.org\/docs\/19\/sql-repack.html\" data-type=\"link\" data-id=\"https:\/\/www.postgresql.org\/docs\/19\/sql-repack.html\" target=\"_blank\" rel=\"noreferrer noopener\">REPACK<\/a><\/code>, which also has a <code>CONCURRENTLY<\/code> option that allows other transactions to use the table while it is being repacked.<\/p>\n\n\n\n<h2 id=\"h-zero-downtime\" class=\"wp-block-heading\">Zero downtime?<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Speaking about <code>REPACK<\/code>, this new feature was also presented by Rajni Baliyan during her presentation about how to achieve zero downtime with PostgreSQL 19.<br><code>REPACK CONCURRENTLY<\/code> allows tables to be reorganized and disk space to be recovered without blocking normal database operations for the entire process. Unlike <code>VACUUM FULL<\/code>, which blocks access to the table during the operation, <code>REPACK CONCURRENTLY<\/code> allows applications to continue reading and writing data while a new copy of the table and its indexes is being created.<br>In the background, PostgreSQL uses logical decoding to capture changes made to the original table during this process and applies them to the new copy. At the end, it briefly takes an exclusive lock to replace the old table and indexes with the new ones.<br><br>An other interesting feature is the new logical sequence synchronization worker, which helps keep sequence values synchronized between the publisher and the subscriber during logical replication.<br>Before PostgreSQL 19, sequence values were not automatically synchronized through logical replication. This could cause problems during major version upgrades, as sequences on the new server could have outdated values and generate duplicate IDs.<br>With PostgreSQL 19, sequences can now be synchronized automatically when a subscription is created. The <code><a href=\"https:\/\/www.postgresql.org\/docs\/19\/sql-altersubscription.html#SQL-ALTERSUBSCRIPTION-PARAMS-REFRESH-SEQUENCES\" data-type=\"link\" data-id=\"https:\/\/www.postgresql.org\/docs\/19\/sql-altersubscription.html#SQL-ALTERSUBSCRIPTION-PARAMS-REFRESH-SEQUENCES\" target=\"_blank\" rel=\"noreferrer noopener\">REFRESH SEQUENCES<\/a><\/code> command can also be used to synchronize them again when needed.<br><br>As you may have guess, the goal of this presentation was to show how new features can help reduce service interruptions during database maintenance and remove the need for maintenance windows. The presentation focused on making database operations easier and safer while keeping services available for users.<br>It was an interesting topic, especially for production environments where downtime must be avoided as much as possible.<\/p>\n\n\n\n<h2 id=\"h-modern-backups-for-postgresql\" class=\"wp-block-heading\">Modern Backups for PostgreSQL<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">I then attended a session about <code><a href=\"https:\/\/www.pghardstorage.org\/\" data-type=\"link\" data-id=\"https:\/\/www.pghardstorage.org\/\" target=\"_blank\" rel=\"noreferrer noopener\">pg_hardstorage<\/a><\/code>, presented by Hans-J\u00fcrgen Sch\u00f6nig.<br><code>pg_hardstorage<\/code> is a modern backup solution for PostgreSQL, designed especially for large environments and critical systems.<br>Unlike traditional backup tools, it uses the PostgreSQL replication protocol to retrieve a base backup and continuously stream WAL files. It does not require an agent or direct shell access on the database server. The tool runs on a separate backup host.<br><br>One interesting feature is its storage system. Each backup is treated as a full backup, but duplicate data blocks are stored only once. This reduces storage requirements without the complexity of traditional incremental backup chains.<br>The continuous WAL streaming also allows point-in-time recovery, making it possible to restore a database to a specific moment in time.<br><br>Another advantage is that <code>pg_hardstorage<\/code> can store backups on a filesystem or S3-compatible object storage. It also supports different PostgreSQL environments, including bare-metal servers, Patroni clusters and Kubernetes deployments.<br><br>Overall, it was an interesting presentation about an alternative approach to PostgreSQL backups, with a strong focus on simplicity, storage efficiency and reliable recovery.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<h2 id=\"h-patroni-the-right-way\" class=\"wp-block-heading\">Patroni the right way<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">I then attended a session presented by Alexander Kukushkin and Polina Bungina, two of the main contributors to Patroni.<br>The presentation explained how Patroni really works behind the scenes, with a special focus on automatic failover and the challenges of managing a high-availability PostgreSQL cluster.<br><br>One important topic was the risk of <em>split-brain<\/em>, when two PostgreSQL nodes believe they are the primary at the same time. The speakers explained why a simple two-node setup is not enough and why quorum and fencing mechanisms are important to prevent this situation.<br>They also explained how Patroni uses a Distributed Configuration Store (DCS), such as etcd, to coordinate the cluster, manage the leader election and keep track of the state of each node.<br>The presentation also covered some important features, such as synchronous replication, standby clusters and DCS failsafe mode. Finally, they presented some upcoming features, including site-aware failover, which will help Patroni make better decisions when a cluster is spread across several data centers.<br><br>This was a very nice session to better understand the internal mechanisms of Patroni and the challenges of building a reliable PostgreSQL high-availability architecture.<\/p>\n\n\n\n<h2 id=\"h-data-quality\" class=\"wp-block-heading\">Data Quality<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Due to meetings with my customers, I unfortunately couldn&#8217;t attend any other sessions on Wednesday. However, I just managed to catch my colleague Herv\u00e9 Schweitzer presentation of our OMrun tool during the &#8220;Silver Sponsor Lightning Talks&#8221;.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/10\/PXL_20261021_140030609-1024x576.jpg\" alt=\"\" class=\"wp-image-48145\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Are you interested in data quality?<br>Take a look here to learn more about OMrun: <a href=\"https:\/\/www.dbi-services.com\/fr\/produits\/omrun\/\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/www.dbi-services.com\/fr\/produits\/omrun\/<\/a><\/p>\n\n\n\n<h2 id=\"h-new-communication-hub-for-the-postgresql-community\" class=\"wp-block-heading\">New communication Hub for the PostgreSQL Community<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">On Thursday, I attended a session presented by Jack Bonatakis about <a href=\"https:\/\/hackorum.dev\/\" data-type=\"link\" data-id=\"https:\/\/hackorum.dev\/\" target=\"_blank\" rel=\"noreferrer noopener\">Hackorum<\/a>, a tool designed to make PostgreSQL mailing lists easier to use for both experts and newcomers.<br>PostgreSQL development relies heavily on mailing lists, but following long email discussions can be difficult, especially when there are many messages.<br>Hackorum provides a modern, forum-style web interface on top of the existing mailing lists. It does not replace them. Instead, it makes discussions easier to read, follow and organize. Some of its main features are:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Better discussion view: messages are grouped into topics, making long conversations easier to follow.<\/li>\n\n\n\n<li>Read tracking: you can see which messages you have already read and continue where you stopped.<\/li>\n\n\n\n<li>Commitfest integration: information about patches and their status is available directly alongside the related discussions.<\/li>\n\n\n\n<li>Tags, notes and favourites: users can organize discussions, save important topics and add personal notes.<\/li>\n\n\n\n<li>Team collaboration: reading status, tags and notes can be shared with other team members.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Compared to traditional mailing lists, Hackorum offers a more visual and user-friendly interface. It helps reduce the number of emails to manage and makes it easier to follow several discussions at the same time. The integration with Commitfest is also useful for PostgreSQL developers who want to follow patches and their progress. <br>One important point is that the mailing lists remain the main source of information. Hackorum simply provides a more convenient way to access and organize their content.<br><br>I found this an interesting initiative that could make the PostgreSQL community more accessible, especially for newcomers who may find the traditional mailing lists difficult to follow.<\/p>\n\n\n\n<h2 id=\"h-monitoring\" class=\"wp-block-heading\">Monitoring<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">I finished the conference with a presentation by Jimmy Angelakos about <code><a href=\"https:\/\/github.com\/pgEdge\/radar\" data-type=\"link\" data-id=\"https:\/\/github.com\/pgEdge\/radar\" target=\"_blank\" rel=\"noreferrer noopener\">radar<\/a><\/code> and <code><a href=\"https:\/\/github.com\/pgEdge\/radar-analyst\" data-type=\"link\" data-id=\"https:\/\/github.com\/pgEdge\/radar-analyst\" target=\"_blank\" rel=\"noreferrer noopener\">radar-analyst<\/a><\/code>, two tools designed to simplify PostgreSQL diagnostics.<br>The idea behind <code>radar<\/code> is simple: instead of installing monitoring agents and collecting information over a long period, you can run a single command to collect a snapshot of the PostgreSQL server and its operating system. <br>The tool is agentless and does not require any additional dependencies. It creates a ZIP archive containing useful diagnostic information, including PostgreSQL configuration, database statistics, replication status, table and index information, as well as system resources such as CPU, memory and disk I\/O.<br><br>The second tool, <code>radar-analyst<\/code>, analyzes this archive and helps identify potential problems. It uses predefined rules to check different areas, including PostgreSQL configuration, workload, replication and operating system settings. Each finding includes an explanation and recommendations to help fix the problem.<br><br>Compared to traditional monitoring solutions, this approach has several advantages. There is no need to install or maintain an agent, and a diagnostic snapshot can be collected when a problem occurs, even if no monitoring was configured beforehand.<br><br>I found this to be a practical approach to PostgreSQL troubleshooting. It can be particularly useful for support teams and DBAs who need to quickly understand the state of a database server without spending hours collecting information manually.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Vacuum and autovacuum I started the second day of PGConf.EU with a session about vacuum and autovacuum, presented by Teresa Lopes.After a short introduction to how MVCC works, she presented the different elements related to autovacuum:What are the different phases of autovacuum? What can trigger autovacuum? Which parameters can influence autovacuum? All these points were&hellip;&nbsp;<\/p>\n","protected":false},"author":30,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"neve_meta_sidebar":"","neve_meta_container":"","neve_meta_enable_content_width":"","neve_meta_content_width":0,"neve_meta_title_alignment":"","neve_meta_author_avatar":"","neve_post_elements_order":"","neve_meta_disable_header":"","neve_meta_disable_footer":"","neve_meta_disable_title":"","neve_meta_reading_time":"","_themeisle_gutenberg_block_has_review":false,"footnotes":""},"categories":[83],"tags":[1124,18442,20336,1714],"class_list":["post-48142","post","type-post","status-publish","format-standard","category-postgresql","tag-conferences","tag-feedback","tag-pgconf","tag-pgconfeu"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v28.8 (Yoast SEO v28.9) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>PGConf.EU 2026 \u2013 Day 2 &amp; 3 - dbi services 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\/pgconf-eu-2026-day-2-3\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"PGConf.EU 2026 \u2013 Day 2 &amp; 3\" \/>\n<meta property=\"og:description\" content=\"Vacuum and autovacuum I started the second day of PGConf.EU with a session about vacuum and autovacuum, presented by Teresa Lopes.After a short introduction to how MVCC works, she presented the different elements related to autovacuum:What are the different phases of autovacuum? What can trigger autovacuum? Which parameters can influence autovacuum? All these points were&hellip;&nbsp;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/pgconf-eu-2026-day-2-3\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi services Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/dbiservices\/\" \/>\n<meta property=\"article:published_time\" content=\"2026-10-26T21:23:07+00:00\" \/>\n<meta name=\"author\" content=\"Jo\u00ebl Cattin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@dbiservices\" \/>\n<meta name=\"twitter:site\" content=\"@dbiservices\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jo\u00ebl Cattin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 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\\\/pgconf-eu-2026-day-2-3\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/pgconf-eu-2026-day-2-3\\\/\"},\"author\":{\"name\":\"Jo\u00ebl Cattin\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/caeaf637485f295f1be42de07b3ac4cf\"},\"headline\":\"PGConf.EU 2026 \u2013 Day 2 &amp; 3\",\"datePublished\":\"2026-10-26T21:23:07+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/pgconf-eu-2026-day-2-3\\\/\"},\"wordCount\":1386,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/pgconf-eu-2026-day-2-3\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/10\\\/PXL_20261021_140030609-1024x576.jpg\",\"keywords\":[\"Conferences\",\"feedback\",\"pgconf\",\"PGConf.EU\"],\"articleSection\":[\"PostgreSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/pgconf-eu-2026-day-2-3\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/pgconf-eu-2026-day-2-3\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/pgconf-eu-2026-day-2-3\\\/\",\"name\":\"PGConf.EU 2026 \u2013 Day 2 &amp; 3 - dbi services Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/pgconf-eu-2026-day-2-3\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/pgconf-eu-2026-day-2-3\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/10\\\/PXL_20261021_140030609-1024x576.jpg\",\"datePublished\":\"2026-10-26T21:23:07+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/pgconf-eu-2026-day-2-3\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/pgconf-eu-2026-day-2-3\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/pgconf-eu-2026-day-2-3\\\/#primaryimage\",\"url\":\"\",\"contentUrl\":\"\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/pgconf-eu-2026-day-2-3\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"PGConf.EU 2026 \u2013 Day 2 &amp; 3\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\",\"name\":\"dbi services Blog\",\"description\":\"#BeSharing\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/#organization\"},\"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\":\"Organization\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/#organization\",\"name\":\"dbi services\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/dbi-services-logo.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/dbi-services-logo.png\",\"width\":512,\"height\":512,\"caption\":\"dbi services\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/dbiservices\\\/\",\"https:\\\/\\\/x.com\\\/dbiservices\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/dbi-services\\\/\",\"https:\\\/\\\/www.youtube.com\\\/user\\\/dbiservices\"],\"description\":\"Swiss IT consulting and services company specialized in efficient data infrastructures and platforms: databases, application servers, cloud, DevOps, digitalization, analytics, data quality and monitoring. Headquartered in Del\u00e9mont with offices in Nyon, Basel, Bern and Zurich.\",\"email\":\"info@dbi-services.com\",\"telephone\":\"+41 32 422 96 00\",\"legalName\":\"dbi services SA\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/caeaf637485f295f1be42de07b3ac4cf\",\"name\":\"Jo\u00ebl Cattin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/08\\\/JOC_web-scaled.jpg\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/08\\\/JOC_web-scaled.jpg\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/08\\\/JOC_web-scaled.jpg\",\"caption\":\"Jo\u00ebl Cattin\"},\"description\":\"Jo\u00ebl Cattin has more than seven years of experience in database management, specializing in Oracle solutions including Data Guard, RMAN, Oracle Database Appliance (ODA), Real Application Clusters (RAC), and APEX development, alongside PostgreSQL and MySQL. He is also experienced with AWS cloud solutions and Ansible-based IT automation. He holds Oracle Database 12c Administrator Certified Professional, EDB Postgres Advanced Server Certified Professional, RedHat Certified System Administrator, and ITIL V3 Foundation certifications, and leads three InSite Workshops (Oracle Basics, Linux for DBAs, and Ansible). He holds a degree from ESIG Del\u00e9mont.\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/author\\\/joel-cattin\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"PGConf.EU 2026 \u2013 Day 2 &amp; 3 - dbi services 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\/pgconf-eu-2026-day-2-3\/","og_locale":"en_US","og_type":"article","og_title":"PGConf.EU 2026 \u2013 Day 2 &amp; 3","og_description":"Vacuum and autovacuum I started the second day of PGConf.EU with a session about vacuum and autovacuum, presented by Teresa Lopes.After a short introduction to how MVCC works, she presented the different elements related to autovacuum:What are the different phases of autovacuum? What can trigger autovacuum? Which parameters can influence autovacuum? All these points were&hellip;&nbsp;","og_url":"https:\/\/www.dbi-services.com\/blog\/pgconf-eu-2026-day-2-3\/","og_site_name":"dbi services Blog","article_publisher":"https:\/\/www.facebook.com\/dbiservices\/","article_published_time":"2026-10-26T21:23:07+00:00","author":"Jo\u00ebl Cattin","twitter_card":"summary_large_image","twitter_creator":"@dbiservices","twitter_site":"@dbiservices","twitter_misc":{"Written by":"Jo\u00ebl Cattin","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/pgconf-eu-2026-day-2-3\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/pgconf-eu-2026-day-2-3\/"},"author":{"name":"Jo\u00ebl Cattin","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/caeaf637485f295f1be42de07b3ac4cf"},"headline":"PGConf.EU 2026 \u2013 Day 2 &amp; 3","datePublished":"2026-10-26T21:23:07+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/pgconf-eu-2026-day-2-3\/"},"wordCount":1386,"commentCount":0,"publisher":{"@id":"https:\/\/www.dbi-services.com\/#organization"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/pgconf-eu-2026-day-2-3\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/10\/PXL_20261021_140030609-1024x576.jpg","keywords":["Conferences","feedback","pgconf","PGConf.EU"],"articleSection":["PostgreSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/pgconf-eu-2026-day-2-3\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/pgconf-eu-2026-day-2-3\/","url":"https:\/\/www.dbi-services.com\/blog\/pgconf-eu-2026-day-2-3\/","name":"PGConf.EU 2026 \u2013 Day 2 &amp; 3 - dbi services Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/pgconf-eu-2026-day-2-3\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/pgconf-eu-2026-day-2-3\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/10\/PXL_20261021_140030609-1024x576.jpg","datePublished":"2026-10-26T21:23:07+00:00","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/pgconf-eu-2026-day-2-3\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/pgconf-eu-2026-day-2-3\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/pgconf-eu-2026-day-2-3\/#primaryimage","url":"","contentUrl":""},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/pgconf-eu-2026-day-2-3\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"PGConf.EU 2026 \u2013 Day 2 &amp; 3"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi services Blog","description":"#BeSharing","publisher":{"@id":"https:\/\/www.dbi-services.com\/#organization"},"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":"Organization","@id":"https:\/\/www.dbi-services.com\/#organization","name":"dbi services","url":"https:\/\/www.dbi-services.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/09\/dbi-services-logo.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/09\/dbi-services-logo.png","width":512,"height":512,"caption":"dbi services"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/dbiservices\/","https:\/\/x.com\/dbiservices","https:\/\/www.linkedin.com\/company\/dbi-services\/","https:\/\/www.youtube.com\/user\/dbiservices"],"description":"Swiss IT consulting and services company specialized in efficient data infrastructures and platforms: databases, application servers, cloud, DevOps, digitalization, analytics, data quality and monitoring. Headquartered in Del\u00e9mont with offices in Nyon, Basel, Bern and Zurich.","email":"info@dbi-services.com","telephone":"+41 32 422 96 00","legalName":"dbi services SA"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/caeaf637485f295f1be42de07b3ac4cf","name":"Jo\u00ebl Cattin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/08\/JOC_web-scaled.jpg","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/08\/JOC_web-scaled.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/08\/JOC_web-scaled.jpg","caption":"Jo\u00ebl Cattin"},"description":"Jo\u00ebl Cattin has more than seven years of experience in database management, specializing in Oracle solutions including Data Guard, RMAN, Oracle Database Appliance (ODA), Real Application Clusters (RAC), and APEX development, alongside PostgreSQL and MySQL. He is also experienced with AWS cloud solutions and Ansible-based IT automation. He holds Oracle Database 12c Administrator Certified Professional, EDB Postgres Advanced Server Certified Professional, RedHat Certified System Administrator, and ITIL V3 Foundation certifications, and leads three InSite Workshops (Oracle Basics, Linux for DBAs, and Ansible). He holds a degree from ESIG Del\u00e9mont.","url":"https:\/\/www.dbi-services.com\/blog\/author\/joel-cattin\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/48142","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\/30"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=48142"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/48142\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=48142"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=48142"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=48142"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}