{"id":17097,"date":"2022-01-31T10:02:07","date_gmt":"2022-01-31T09:02:07","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/postgresql-15-new-function-to-list-flags-associated-to-gucs\/"},"modified":"2022-01-31T10:02:07","modified_gmt":"2022-01-31T09:02:07","slug":"postgresql-15-new-function-to-list-flags-associated-to-gucs","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/postgresql-15-new-function-to-list-flags-associated-to-gucs\/","title":{"rendered":"PostgreSQL 15: New function to list flags associated to GUCs"},"content":{"rendered":"<p>As development of PostgreSQL 15 is on its way, more and more features get committed. Today we&#8217;ll look at a new feature which is not a hammer feature, but a nice thing to have and to know about. <\/p>\n<p>If you take a look at how many settings PostgreSQL comes with as of today, there are 353 (This is PostgreSQL 15dev):<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">\npostgres=# select count(*) from pg_settings ;\n count \n-------\n   353\n(1 row)\n<\/pre>\n<p>Some of those settings are available in the default postgresql.conf, which is created by <a href=\"https:\/\/www.postgresql.org\/docs\/current\/app-initdb.html\">initdb<\/a>, others not. Some settings can be re-setted, while you can&#8217;t do that for others. <\/p>\n<p>The new function pg_settings_get_flags gives you some more insights into this. To start, lets see how many distinct flags are available right now:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">\npostgres=# select distinct flags from (select pg_settings_get_flags(name) as flags from pg_settings) as x;\n              flags               \n----------------------------------\n {EXPLAIN}\n {}\n {EXPLAIN,NOT_IN_SAMPLE}\n {NOT_IN_SAMPLE,RUNTIME_COMPUTED}\n {NOT_IN_SAMPLE}\n {NO_RESET_ALL,NOT_IN_SAMPLE}\n(6 rows)\n<\/pre>\n<p>The return type of the function is a text array and this is what I can see on my instance. The meaning of the flags is (stolen from <a href=\"https:\/\/git.postgresql.org\/gitweb\/?p=postgresql.git;a=commitdiff;h=d10e41d4238e7dcd23968230939c0c59cbcb41c2#patch1\" target=\"_blank\" rel=\"noopener\">here<\/a>):<\/p>\n<ul>\n<li>EXPLAIN: parameters included in EXPLAIN command<\/li>\n<li>NO_SHOW_ALL: parameters excluded from SHOW ALL commands<\/li>\n<li>NO_RESET_ALL: parameters excluded from RESET ALL commands<\/li>\n<li>NOT_IN_SAMPLE: parameters not included in postgresql.conf by default<\/li>\n<li>RUNTIME_COMPUTED: runtime-computed parameters<\/li>\n<\/ul>\n<p>If you, for example, want to know which settings are not included in the default postgresql.conf, you can use the new function for that:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">\npostgres=# with flags_all as (select name,pg_settings_get_flags(name) as flags from pg_settings)\n           select * \n             from flags_all \n            where flags_all.flags @&gt; ARRAY['NOT_IN_SAMPLE'];\n               name               |              flags               \n----------------------------------+----------------------------------\n allow_in_place_tablespaces       | {NOT_IN_SAMPLE}\n allow_system_table_mods          | {NOT_IN_SAMPLE}\n application_name                 | {NOT_IN_SAMPLE}\n backtrace_functions              | {NOT_IN_SAMPLE}\n block_size                       | {NOT_IN_SAMPLE}\n data_checksums                   | {NOT_IN_SAMPLE,RUNTIME_COMPUTED}\n data_directory_mode              | {NOT_IN_SAMPLE,RUNTIME_COMPUTED}\n debug_assertions                 | {NOT_IN_SAMPLE}\n debug_discard_caches             | {NOT_IN_SAMPLE}\n force_parallel_mode              | {EXPLAIN,NOT_IN_SAMPLE}\n ignore_checksum_failure          | {NOT_IN_SAMPLE}\n ignore_invalid_pages             | {NOT_IN_SAMPLE}\n ignore_system_indexes            | {NOT_IN_SAMPLE}\n in_hot_standby                   | {NOT_IN_SAMPLE}\n integer_datetimes                | {NOT_IN_SAMPLE}\n jit_debugging_support            | {NOT_IN_SAMPLE}\n jit_dump_bitcode                 | {NOT_IN_SAMPLE}\n jit_expressions                  | {NOT_IN_SAMPLE}\n jit_profiling_support            | {NOT_IN_SAMPLE}\n jit_tuple_deforming              | {NOT_IN_SAMPLE}\n lc_collate                       | {NOT_IN_SAMPLE}\n lc_ctype                         | {NOT_IN_SAMPLE}\n max_function_args                | {NOT_IN_SAMPLE}\n max_identifier_length            | {NOT_IN_SAMPLE}\n max_index_keys                   | {NOT_IN_SAMPLE}\n post_auth_delay                  | {NOT_IN_SAMPLE}\n pre_auth_delay                   | {NOT_IN_SAMPLE}\n remove_temp_files_after_crash    | {NOT_IN_SAMPLE}\n segment_size                     | {NOT_IN_SAMPLE}\n server_encoding                  | {NOT_IN_SAMPLE}\n server_version                   | {NOT_IN_SAMPLE}\n server_version_num               | {NOT_IN_SAMPLE}\n shared_memory_size               | {NOT_IN_SAMPLE,RUNTIME_COMPUTED}\n shared_memory_size_in_huge_pages | {NOT_IN_SAMPLE,RUNTIME_COMPUTED}\n ssl_library                      | {NOT_IN_SAMPLE}\n trace_notify                     | {NOT_IN_SAMPLE}\n trace_recovery_messages          | {NOT_IN_SAMPLE}\n trace_sort                       | {NOT_IN_SAMPLE}\n transaction_deferrable           | {NO_RESET_ALL,NOT_IN_SAMPLE}\n transaction_isolation            | {NO_RESET_ALL,NOT_IN_SAMPLE}\n transaction_read_only            | {NO_RESET_ALL,NOT_IN_SAMPLE}\n wal_block_size                   | {NOT_IN_SAMPLE}\n wal_consistency_checking         | {NOT_IN_SAMPLE}\n wal_segment_size                 | {NOT_IN_SAMPLE,RUNTIME_COMPUTED}\n zero_damaged_pages               | {NOT_IN_SAMPLE}\n(45 rows)\n<\/pre>\n<p>All these are mostly developer or tracing settings, and are therefore not included in the default postgresql.conf. You could ask: Which parameters are not reset if you execute a <a href=\"https:\/\/www.postgresql.org\/docs\/current\/sql-reset.html\" target=\"_blank\" rel=\"noopener\">reset all<\/a>:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">\npostgres=# with flags_all as (select name,pg_settings_get_flags(name) as flags from pg_settings)\n           select * \n             from flags_all \n            where flags_all.flags @&gt; ARRAY['NO_RESET_ALL'];\n          name          |            flags             \n------------------------+------------------------------\n transaction_deferrable | {NO_RESET_ALL,NOT_IN_SAMPLE}\n transaction_isolation  | {NO_RESET_ALL,NOT_IN_SAMPLE}\n transaction_read_only  | {NO_RESET_ALL,NOT_IN_SAMPLE}\n(3 rows)\n<\/pre>\n<p>&#8230; or combine two or more flags in your query:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">\npostgres=# with flags_all as (select name,pg_settings_get_flags(name) as flags from pg_settings)\n           select * \n             from flags_all \n            where flags_all.flags @&gt; ARRAY['EXPLAIN','NOT_IN_SAMPLE'];\n        name         |          flags          \n---------------------+-------------------------\n force_parallel_mode | {EXPLAIN,NOT_IN_SAMPLE}\n(1 row)\n<\/pre>\n<p>Nice little feature.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>As development of PostgreSQL 15 is on its way, more and more features get committed. Today we&#8217;ll look at a new feature which is not a hammer feature, but a nice thing to have and to know about. If you take a look at how many settings PostgreSQL comes with as of today, there are&hellip;&nbsp;<\/p>\n","protected":false},"author":28,"featured_media":0,"comment_status":"open","ping_status":"open","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-17097","post","type-post","status-publish","format-standard","hentry","category-database"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v28.8 (Yoast SEO v28.8) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>PostgreSQL 15: New function to list flags associated to GUCs - 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-15-new-function-to-list-flags-associated-to-gucs\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"PostgreSQL 15: New function to list flags associated to GUCs\" \/>\n<meta property=\"og:description\" content=\"As development of PostgreSQL 15 is on its way, more and more features get committed. Today we&#8217;ll look at a new feature which is not a hammer feature, but a nice thing to have and to know about. If you take a look at how many settings PostgreSQL comes with as of today, there are&hellip;&nbsp;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/postgresql-15-new-function-to-list-flags-associated-to-gucs\/\" \/>\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=\"2022-01-31T09:02:07+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=\"4 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-15-new-function-to-list-flags-associated-to-gucs\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/postgresql-15-new-function-to-list-flags-associated-to-gucs\\\/\"},\"author\":{\"name\":\"Open source Team\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/0b4548362cac3eeff8b3eaf329e3530a\"},\"headline\":\"PostgreSQL 15: New function to list flags associated to GUCs\",\"datePublished\":\"2022-01-31T09:02:07+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/postgresql-15-new-function-to-list-flags-associated-to-gucs\\\/\"},\"wordCount\":262,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#organization\"},\"articleSection\":[\"Database\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/postgresql-15-new-function-to-list-flags-associated-to-gucs\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/postgresql-15-new-function-to-list-flags-associated-to-gucs\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/postgresql-15-new-function-to-list-flags-associated-to-gucs\\\/\",\"name\":\"PostgreSQL 15: New function to list flags associated to GUCs - dbi services | Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"datePublished\":\"2022-01-31T09:02:07+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/postgresql-15-new-function-to-list-flags-associated-to-gucs\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/postgresql-15-new-function-to-list-flags-associated-to-gucs\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/postgresql-15-new-function-to-list-flags-associated-to-gucs\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"PostgreSQL 15: New function to list flags associated to GUCs\"}]},{\"@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\\\/blog\\\/#organization\"},\"alternateName\":\"dbi Blog\",\"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\\\/blog\\\/#organization\",\"name\":\"dbi services\",\"alternateName\":\"dbi\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\",\"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 specialised 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 15: New function to list flags associated to GUCs - 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-15-new-function-to-list-flags-associated-to-gucs\/","og_locale":"en_US","og_type":"article","og_title":"PostgreSQL 15: New function to list flags associated to GUCs","og_description":"As development of PostgreSQL 15 is on its way, more and more features get committed. Today we&#8217;ll look at a new feature which is not a hammer feature, but a nice thing to have and to know about. If you take a look at how many settings PostgreSQL comes with as of today, there are&hellip;&nbsp;","og_url":"https:\/\/www.dbi-services.com\/blog\/postgresql-15-new-function-to-list-flags-associated-to-gucs\/","og_site_name":"dbi services | Blog","article_publisher":"https:\/\/www.facebook.com\/dbiservices\/","article_published_time":"2022-01-31T09:02:07+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":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/postgresql-15-new-function-to-list-flags-associated-to-gucs\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/postgresql-15-new-function-to-list-flags-associated-to-gucs\/"},"author":{"name":"Open source Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0b4548362cac3eeff8b3eaf329e3530a"},"headline":"PostgreSQL 15: New function to list flags associated to GUCs","datePublished":"2022-01-31T09:02:07+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/postgresql-15-new-function-to-list-flags-associated-to-gucs\/"},"wordCount":262,"commentCount":0,"publisher":{"@id":"https:\/\/www.dbi-services.com\/blog\/#organization"},"articleSection":["Database"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/postgresql-15-new-function-to-list-flags-associated-to-gucs\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/postgresql-15-new-function-to-list-flags-associated-to-gucs\/","url":"https:\/\/www.dbi-services.com\/blog\/postgresql-15-new-function-to-list-flags-associated-to-gucs\/","name":"PostgreSQL 15: New function to list flags associated to GUCs - dbi services | Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2022-01-31T09:02:07+00:00","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/postgresql-15-new-function-to-list-flags-associated-to-gucs\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/postgresql-15-new-function-to-list-flags-associated-to-gucs\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/postgresql-15-new-function-to-list-flags-associated-to-gucs\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"PostgreSQL 15: New function to list flags associated to GUCs"}]},{"@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\/blog\/#organization"},"alternateName":"dbi Blog","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\/blog\/#organization","name":"dbi services","alternateName":"dbi","url":"https:\/\/www.dbi-services.com\/blog\/","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 specialised 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\/17097","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=17097"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/17097\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=17097"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=17097"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=17097"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}