{"id":27030,"date":"2023-08-28T11:36:54","date_gmt":"2023-08-28T09:36:54","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/?p=27030"},"modified":"2023-08-28T11:36:54","modified_gmt":"2023-08-28T09:36:54","slug":"postgresql-16-playing-with-pg_stat_io-2-evictions","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/postgresql-16-playing-with-pg_stat_io-2-evictions\/","title":{"rendered":"PostgreSQL 16: Playing with pg_stat_io (2) \u2013 evictions"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">In the <a href=\"https:\/\/www.dbi-services.com\/blog\/postgresql-16-playing-with-pg_stat_io-1-extends\/\" target=\"_blank\" rel=\"noreferrer noopener\">last post<\/a> in this little series we&#8217;ve looked at the &#8220;extends&#8221; statistic in <a href=\"https:\/\/www.postgresql.org\/docs\/16\/monitoring-stats.html#MONITORING-PG-STAT-IO-VIEW\" target=\"_blank\" rel=\"noreferrer noopener\">pg_stat_io<\/a>. In this post we&#8217;ll look at the &#8220;eviction&#8221; statistic. Before we go into the details: What is an eviction? Imagine the buffer cache is currently full and PostgreSQL needs to load another block from disk (or the OS cache). For this to work a block which is currently cached in the buffer cache must be evicted (kicked out) to make room for the block to be loaded. And this is what the statistic is about: Tracking the number of evictions. This statistic can help you in identifying if the sizing of your buffer cache (<a href=\"https:\/\/www.postgresql.org\/docs\/16\/runtime-config-resource.html\" target=\"_blank\" rel=\"noreferrer noopener\">shared_buffers<\/a>) is either too small or too large. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The default size of the buffer cache on Linux is 128MB, and this is what we currently have:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; highlight: [1]; title: ; notranslate\" title=\"\">\npostgres=# show shared_buffers;\n shared_buffers \n----------------\n 128MB\n(1 row)\n<\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">Using the <a href=\"https:\/\/www.postgresql.org\/docs\/16\/pgbuffercache.html\" target=\"_blank\" rel=\"noreferrer noopener\">pg_buffercache<\/a> extension we can check how many blocks are currently used right after the instance was started:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; highlight: [1]; title: ; notranslate\" title=\"\">\npostgres=# select count(*) from pg_buffercache where relfilenode is not null;\n count \n-------\n   287\n(1 row)\n\n<\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">This means that 287*8192 (again the block size of the instance) is currently used, which is a bit less than 2.3MB, 2351104 bytes.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">This also means that we should not see any evictions in the pg_stat_io view:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; highlight: [1,2,3,4,5]; title: ; notranslate\" title=\"\">\npostgres=# select backend_type,evictions \n             from pg_stat_io \n            where backend_type = &#039;client backend&#039;\n              and context = &#039;normal&#039;\n              and object =&#039;relation&#039;;\n  backend_type  | evictions \n----------------+-----------\n client backend |         0\n(1 row)\n<\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">To see any eviction we need to load around 126MB of data, so let&#8217;s do this:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; highlight: [1,3,4,6]; title: ; notranslate\" title=\"\">\npostgres=# create table t ( a int, b text, c text, d text );\nCREATE TABLE\npostgres=# insert into t select i,  md5(i::text), md5(i::text), md5(i::text) \n             from generate_series(1,1000000) i;\nINSERT 0 1000000\npostgres=# select pg_size_pretty(pg_relation_size(&#039;t&#039;));\n pg_size_pretty \n----------------\n 128 MB\n(1 row)\n<\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">This should be enough data to already see some evictions:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; highlight: [1,2,3,4,5]; title: ; notranslate\" title=\"\">\npostgres=# select backend_type,evictions \n             from pg_stat_io \n            where backend_type = &#039;client backend&#039;\n              and context = &#039;normal&#039;\n              and object =&#039;relation&#039;;\n  backend_type  | evictions \n----------------+-----------\n client backend |       288\n(1 row)\n<\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">Let&#8217;s have a look how much currently is cached for our table:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\npostgres=# select c.relname, count(*) AS buffers\n  from pg_class c\n inner join pg_buffercache b\n       on b.relfilenode=c.relfilenode\n inner join pg_database d\n       on (b.reldatabase=d.oid AND d.datname=current_database())\n where c.relname = &#039;t&#039;\n group by c.relname;\n\n relname | buffers \n---------+---------\n t       |   16237\n(1 row)\n\n<\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">This are (16237*8)\/1024, around 127 MB of data. As the table is 128MB big and around 2MB was already used in the buffer cache some evictions needed to happen. 288 evictions means a bit more than 2MB so this seems to be consistent.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">If we create a copy of this table like follows and then again have a look at the evictions but this time for all contexts we&#8217;ll see something like this:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\npostgres=# create table t2 as select * from t;\nSELECT 1000000\npostgres=# select backend_type,evictions,context \n             from pg_stat_io \n            where backend_type = &#039;client backend&#039;\n              and object =&#039;relation&#039;;\n  backend_type  | evictions |  context  \n----------------+-----------+-----------\n client backend |        32 | bulkread\n client backend |      2048 | bulkwrite\n client backend |       323 | normal\n client backend |         0 | vacuum\n<\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">bulkread and bulkwrite means the blocks have been taken out of shared buffers and instead have been placed in a ring buffer for use of bulk I\/O operations. The same is true for vacuum operations:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\npostgres=# update t set d = &#039;xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx&#039;;\nUPDATE 1000000\npostgres=# vacuum t;\nVACUUM\npostgres=# select backend_type,evictions,context \n             from pg_stat_io \n            where backend_type = &#039;client backend&#039;\n              and object =&#039;relation&#039;;\n  backend_type  | evictions |  context  \n----------------+-----------+-----------\n client backend |     16102 | bulkread\n client backend |      2048 | bulkwrite\n client backend |     18611 | normal\n client backend |        32 | vacuum\n\n<\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">To summarize: When you see many evictions in context &#8220;normal&#8221; this might give you the hint that you buffer cache is too small. Seeing almost no evictions means probably your buffer cache is oversized.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In the last post in this little series we&#8217;ve looked at the &#8220;extends&#8221; statistic in pg_stat_io. In this post we&#8217;ll look at the &#8220;eviction&#8221; statistic. Before we go into the details: What is an eviction? Imagine the buffer cache is currently full and PostgreSQL needs to load another block from disk (or the OS cache).&hellip;&nbsp;<\/p>\n","protected":false},"author":28,"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":[4133],"tags":[],"class_list":["post-27030","post","type-post","status-publish","format-standard","category-database"],"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>PostgreSQL 16: Playing with pg_stat_io (2) \u2013 evictions - 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\/postgresql-16-playing-with-pg_stat_io-2-evictions\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"PostgreSQL 16: Playing with pg_stat_io (2) \u2013 evictions\" \/>\n<meta property=\"og:description\" content=\"In the last post in this little series we&#8217;ve looked at the &#8220;extends&#8221; statistic in pg_stat_io. In this post we&#8217;ll look at the &#8220;eviction&#8221; statistic. Before we go into the details: What is an eviction? Imagine the buffer cache is currently full and PostgreSQL needs to load another block from disk (or the OS cache).&hellip;&nbsp;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/postgresql-16-playing-with-pg_stat_io-2-evictions\/\" \/>\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=\"2023-08-28T09:36:54+00:00\" \/>\n<meta name=\"author\" content=\"Open source Team\" \/>\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=\"Open source Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 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-16-playing-with-pg_stat_io-2-evictions\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/postgresql-16-playing-with-pg_stat_io-2-evictions\\\/\"},\"author\":{\"name\":\"Open source Team\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/0b4548362cac3eeff8b3eaf329e3530a\"},\"headline\":\"PostgreSQL 16: Playing with pg_stat_io (2) \u2013 evictions\",\"datePublished\":\"2023-08-28T09:36:54+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/postgresql-16-playing-with-pg_stat_io-2-evictions\\\/\"},\"wordCount\":386,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/#organization\"},\"articleSection\":[\"Database\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/postgresql-16-playing-with-pg_stat_io-2-evictions\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/postgresql-16-playing-with-pg_stat_io-2-evictions\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/postgresql-16-playing-with-pg_stat_io-2-evictions\\\/\",\"name\":\"PostgreSQL 16: Playing with pg_stat_io (2) \u2013 evictions - dbi services Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"datePublished\":\"2023-08-28T09:36:54+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/postgresql-16-playing-with-pg_stat_io-2-evictions\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/postgresql-16-playing-with-pg_stat_io-2-evictions\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/postgresql-16-playing-with-pg_stat_io-2-evictions\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"PostgreSQL 16: Playing with pg_stat_io (2) \u2013 evictions\"}]},{\"@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\\\/0b4548362cac3eeff8b3eaf329e3530a\",\"name\":\"Open source Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/05\\\/open-source-author.png\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/05\\\/open-source-author.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/05\\\/open-source-author.png\",\"caption\":\"Open source Team\"},\"description\":\"Posts published under the Open source Team account are collective contributions by the dbi services open infrastructure consultants. The practice covers open-source databases and platforms, PostgreSQL first of all, along with MySQL, MariaDB, and Linux, from architecture, replication, and high availability to performance tuning and operations under service level agreements, and contributes actively to the PostgreSQL community.\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/author\\\/open-source-team\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"PostgreSQL 16: Playing with pg_stat_io (2) \u2013 evictions - 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\/postgresql-16-playing-with-pg_stat_io-2-evictions\/","og_locale":"en_US","og_type":"article","og_title":"PostgreSQL 16: Playing with pg_stat_io (2) \u2013 evictions","og_description":"In the last post in this little series we&#8217;ve looked at the &#8220;extends&#8221; statistic in pg_stat_io. In this post we&#8217;ll look at the &#8220;eviction&#8221; statistic. Before we go into the details: What is an eviction? Imagine the buffer cache is currently full and PostgreSQL needs to load another block from disk (or the OS cache).&hellip;&nbsp;","og_url":"https:\/\/www.dbi-services.com\/blog\/postgresql-16-playing-with-pg_stat_io-2-evictions\/","og_site_name":"dbi services Blog","article_publisher":"https:\/\/www.facebook.com\/dbiservices\/","article_published_time":"2023-08-28T09:36:54+00:00","author":"Open source Team","twitter_card":"summary_large_image","twitter_creator":"@dbiservices","twitter_site":"@dbiservices","twitter_misc":{"Written by":"Open source Team","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/postgresql-16-playing-with-pg_stat_io-2-evictions\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/postgresql-16-playing-with-pg_stat_io-2-evictions\/"},"author":{"name":"Open source Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0b4548362cac3eeff8b3eaf329e3530a"},"headline":"PostgreSQL 16: Playing with pg_stat_io (2) \u2013 evictions","datePublished":"2023-08-28T09:36:54+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/postgresql-16-playing-with-pg_stat_io-2-evictions\/"},"wordCount":386,"commentCount":0,"publisher":{"@id":"https:\/\/www.dbi-services.com\/#organization"},"articleSection":["Database"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/postgresql-16-playing-with-pg_stat_io-2-evictions\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/postgresql-16-playing-with-pg_stat_io-2-evictions\/","url":"https:\/\/www.dbi-services.com\/blog\/postgresql-16-playing-with-pg_stat_io-2-evictions\/","name":"PostgreSQL 16: Playing with pg_stat_io (2) \u2013 evictions - dbi services Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2023-08-28T09:36:54+00:00","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/postgresql-16-playing-with-pg_stat_io-2-evictions\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/postgresql-16-playing-with-pg_stat_io-2-evictions\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/postgresql-16-playing-with-pg_stat_io-2-evictions\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"PostgreSQL 16: Playing with pg_stat_io (2) \u2013 evictions"}]},{"@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\/0b4548362cac3eeff8b3eaf329e3530a","name":"Open source Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/05\/open-source-author.png","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/05\/open-source-author.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/05\/open-source-author.png","caption":"Open source Team"},"description":"Posts published under the Open source Team account are collective contributions by the dbi services open infrastructure consultants. The practice covers open-source databases and platforms, PostgreSQL first of all, along with MySQL, MariaDB, and Linux, from architecture, replication, and high availability to performance tuning and operations under service level agreements, and contributes actively to the PostgreSQL community.","url":"https:\/\/www.dbi-services.com\/blog\/author\/open-source-team\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/27030","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\/28"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=27030"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/27030\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=27030"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=27030"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=27030"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}