{"id":6664,"date":"2024-12-26T11:34:32","date_gmt":"2024-12-26T11:34:32","guid":{"rendered":"https:\/\/test.opensource-db.in\/wp1\/?p=6664"},"modified":"2024-12-26T11:38:10","modified_gmt":"2024-12-26T11:38:10","slug":"mastering-the-pg_settings-view-in-postgresql","status":"publish","type":"post","link":"https:\/\/test.opensource-db.in\/wp1\/mastering-the-pg_settings-view-in-postgresql\/","title":{"rendered":"Mastering the pg_settings view in PostgreSQL"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\">Introduction<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">PostgreSQL, a powerful and highly customizable open-source relational database system, offers a wide range of tools to manage and optimize its configuration. One of the key resources for interacting with PostgreSQL\u2019s settings is the <code>pg_settings<\/code> system catalog view. This view acts as a central interface for administrators and developers to access and modify database configuration parameters. Unlike the <code>SHOW<\/code> and <code>SET<\/code> commands, which allow for basic configuration management, <code>pg_settings<\/code> provides more granular details, such as the minimum and maximum allowable values for parameters, the source of the current settings, and whether changes require a database restart. This blog will explore the uses of&nbsp;the <code>pg_settings<\/code>&nbsp;system catalog view for understanding, viewing, and modifying the PostgreSQL configurations effectively.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Uses of  pg_settings<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">pg_settings is ideal when you need:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>A comprehensive view of current PostgreSQL configuration.<\/li>\n\n\n\n<li>Metadata to understand the implications of specific parameters.<\/li>\n\n\n\n<li>To troubleshoot or debug configuration issues.<\/li>\n\n\n\n<li>To test parameter changes in a live session.<\/li>\n\n\n\n<li>Insights into default settings, minimum\/maximum values, and change contexts.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Step1: Understanding pg_settings<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">The pg_settings table provides a structured view of PostgreSQL configuration parameters. Let&#8217;s examine an example query:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>postgres=# select * from pg_settings;\n-&#091; RECORD 1 ]---+----------------------------------------\nname            | allow_in_place_tablespaces\nsetting         | off\nunit            | \ncategory        | Developer Options\nshort_desc      | Allows tablespaces directly inside pg_tblspc, for testing.\nextra_desc      | \ncontext         | superuser\nvartype         | bool\nsource          | default\nmin_val         | \nmax_val         | \nenumvals        | \nboot_val        | off\nreset_val       | off\nsourcefile      | \nsourceline      | \npending_restart | f<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Let&#8217;s breakdown the pg_settings&#8217; output<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>name<\/strong> : The name of the configuration parameter.<\/li>\n\n\n\n<li><strong>setting<\/strong> : The current value of the parameter.<\/li>\n\n\n\n<li><strong>unit<\/strong> : The unit of the setting, if applicable.<\/li>\n\n\n\n<li><strong>category<\/strong> : The parameter\u2019s category (e.g., Memory, Developer Options).<\/li>\n\n\n\n<li><strong>short_desc<\/strong> : A brief description of what the parameter does.<\/li>\n\n\n\n<li><strong>extra_desc<\/strong> : An extended description of the parameter.<\/li>\n\n\n\n<li><strong>context<\/strong> : Where and how the parameter can be modified (e.g., superuser, session).<\/li>\n\n\n\n<li><strong>vartype<\/strong> : The type of the value (e.g., integer, boolean).<\/li>\n\n\n\n<li><strong>source<\/strong> : The origin of the current value.<\/li>\n\n\n\n<li><strong>min_val<\/strong> and <strong>max_val<\/strong> : The allowed range for the setting, if applicable.<\/li>\n\n\n\n<li><strong>boot_val<\/strong> : The value used when PostgreSQL starts up.<\/li>\n\n\n\n<li><strong>reset_val<\/strong> : The value that will be used if the parameter is reset.<\/li>\n\n\n\n<li><strong>sourcefile <\/strong>and <strong>sourceline<\/strong> : The configuration file and line number defining the parameter.<\/li>\n\n\n\n<li><strong>pending_restart<\/strong> : Indicates if a restart is pending for the change to take effect.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">A few columns that needs to be highlighted are:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><code>CONTEXT<\/code>: This parameter ascertains whether the parameter value change needs a <code>RESTART<\/code> or <code>SIGHUP<\/code>. <br><code>UNIT<\/code>: You may see a difference between the <code>SHOW<\/code> output and the value seen on the <code>pg_settings.unit<\/code> &#8211; this is because of the measurement units.<br><code>SOURCE<\/code>: As part of our standard database deployments, we follow the best practices of segregating the parameters into:<br>&#8211; parameters that needs restart<br>&#8211; parameters that needs reload<br>&#8211; specific extension related parameters<br>&#8211; custom parameters per instance<br>This approach helps us to to be more cautious while changing the parameters.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Step 2:Viewing a Specific Parameter<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">To view the details of a specific configuration parameter, use a SELECT query:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>postgres=#  SELECT * FROM pg_settings WHERE name = 'log_statement';\n-&#091; RECORD 1 ]---+------------------------------------\nname            | log_statement\nsetting         | none\nunit            | \ncategory        | Reporting and Logging \/ What to Log\nshort_desc      | Sets the type of statements logged.\nextra_desc      | \ncontext         | superuser\nvartype         | enum\nsource          | default\nmin_val         | \nmax_val         | \nenumvals        | {none,ddl,mod,all}\nboot_val        | none\nreset_val       | none\nsourcefile      | \nsourceline      | \npending_restart | f<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">This query will return detailed information about the <code>log_statement<\/code> configuration, including its current value and the possible settings (<code>none<\/code>, <code>ddl<\/code>, <code>mod<\/code>, <code>all<\/code>).<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Step 3:Modifying a Parameter Temporarily<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">To temporarily change a parameter, use the SET command:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>postgres=#  SET log_statement TO mod;\nSET<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">To verify that the change has taken place, run the same query again:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>postgres=#  SELECT * FROM pg_settings WHERE name = 'log_statement';\n-&#091; RECORD 1 ]---+------------------------------------\nname            | log_statement\nsetting         | mod\nunit            | \ncategory        | Reporting and Logging \/ What to Log\nshort_desc      | Sets the type of statements logged.\nextra_desc      | \ncontext         | superuser\nvartype         | enum\nsource          | session\nmin_val         | \nmax_val         | \nenumvals        | {none,ddl,mod,all}\nboot_val        | none\nreset_val       | none\nsourcefile      | \nsourceline      | \npending_restart | f<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">The setting has been updated to mod, and the source column now reflects that the change was made for the current session.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Step 4:Direct Updates in pg_settings<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">While it might seem intuitive to directly update the pg_settings table, this approach is typically ineffective for permanent changes:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>postgres=# UPDATE pg_settings SET setting = 'all' WHERE name = 'log_statement';\n set_config \n------------\n all\n(1 row)\n\nUPDATE 0<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Verify the change using:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>postgres=#  SELECT * FROM pg_settings WHERE name = 'log_statement';\n-&#091; RECORD 1 ]---+------------------------------------\nname            | log_statement\nsetting         | all\nunit            | \ncategory        | Reporting and Logging \/ What to Log\nshort_desc      | Sets the type of statements logged.\nextra_desc      | \ncontext         | superuser\nvartype         | enum\nsource          | session\nmin_val         | \nmax_val         | \nenumvals        | {none,ddl,mod,all}\nboot_val        | none\nreset_val       | none\nsourcefile      | \nsourceline      | \npending_restart | f<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">This confirms that the setting has been applied for the current session. However, as you will see in the next steps, this change will be lost once the server is restarted.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Step 5: Checking with SHOW Command<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">To check the current setting of log_statement after making the change and restarting the database server:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>postgres=# show log_statement;\n log_statement \n---------------\n none\n(1 row)<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Notice: Even though you updated the <code>pg_settings<\/code> view, the setting is still showing as none when queried with SHOW. This is because changes in pg_settings are session-based and temporary, and the underlying configuration hasn&#8217;t been permanently updated.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">In order to make permanent changes to any database configuration parameter(s), you could either update the postgresql.conf file directly with the appropriate value(s) set against the corresponding parameter(s), or use the Alter System Set \u2026 command.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Conclusion<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">The <code>pg_settings<\/code> view is a vital resource for PostgreSQL administrators and developers. It provides an in-depth view of the database&#8217;s configuration settings, enabling you to optimize performance, diagnose issues, and better understand the system\u2019s behavior. By leveraging <code>pg_settings<\/code>, you can manage and fine-tune your PostgreSQL instance with enhanced precision and confidence. Furthermore, it empowers you to track and make informed changes to your configuration, ensuring the system operates at peak performance while meeting specific workload requirements. In essence, mastering <code>pg_settings<\/code> is key to maintaining a robust, efficient, and secure PostgreSQL environment.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Let us know how you handle <code>postgresql.conf<\/code> parameter changes by commenting below.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Introduction PostgreSQL, a powerful and highly customizable open-source relational database system, offers a wide range of tools to manage and [&hellip;]<\/p>\n","protected":false},"author":13,"featured_media":6683,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[1,23,42,89],"tags":[],"class_list":["post-6664","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-others","category-postgresql-14","category-postgresql-15","category-postgresql-16"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Mastering the pg_settings view in PostgreSQL - OpenSource DB<\/title>\n<meta name=\"robots\" content=\"noindex, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Mastering the pg_settings view in PostgreSQL - OpenSource DB\" \/>\n<meta property=\"og:description\" content=\"Introduction PostgreSQL, a powerful and highly customizable open-source relational database system, offers a wide range of tools to manage and [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/test.opensource-db.in\/wp1\/mastering-the-pg_settings-view-in-postgresql\/\" \/>\n<meta property=\"og:site_name\" content=\"OpenSource DB\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/people\/OpenSource-DB\/100072970755470\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-12-26T11:34:32+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-12-26T11:38:10+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/12\/image-15.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1800\" \/>\n\t<meta property=\"og:image:height\" content=\"945\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Shameer Bhupathi\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@opensource_db\" \/>\n<meta name=\"twitter:site\" content=\"@opensource_db\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Shameer Bhupathi\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/mastering-the-pg_settings-view-in-postgresql\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/mastering-the-pg_settings-view-in-postgresql\/\"},\"author\":{\"name\":\"Shameer Bhupathi\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/person\/422480fbefed0b2cee82aeab232110f5\"},\"headline\":\"Mastering the pg_settings view in PostgreSQL\",\"datePublished\":\"2024-12-26T11:34:32+00:00\",\"dateModified\":\"2024-12-26T11:38:10+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/mastering-the-pg_settings-view-in-postgresql\/\"},\"wordCount\":777,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#organization\"},\"image\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/mastering-the-pg_settings-view-in-postgresql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/12\/image-15.png\",\"articleSection\":[\"Others\",\"PostgreSQL 14\",\"PostgreSQL 15\",\"PostgreSQL 16\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/test.opensource-db.in\/wp1\/mastering-the-pg_settings-view-in-postgresql\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/mastering-the-pg_settings-view-in-postgresql\/\",\"url\":\"https:\/\/test.opensource-db.in\/wp1\/mastering-the-pg_settings-view-in-postgresql\/\",\"name\":\"Mastering the pg_settings view in PostgreSQL - OpenSource DB\",\"isPartOf\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/mastering-the-pg_settings-view-in-postgresql\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/mastering-the-pg_settings-view-in-postgresql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/12\/image-15.png\",\"datePublished\":\"2024-12-26T11:34:32+00:00\",\"dateModified\":\"2024-12-26T11:38:10+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/mastering-the-pg_settings-view-in-postgresql\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/test.opensource-db.in\/wp1\/mastering-the-pg_settings-view-in-postgresql\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/mastering-the-pg_settings-view-in-postgresql\/#primaryimage\",\"url\":\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/12\/image-15.png\",\"contentUrl\":\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/12\/image-15.png\",\"width\":1800,\"height\":945},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/mastering-the-pg_settings-view-in-postgresql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/test.opensource-db.in\/wp1\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Mastering the pg_settings view in PostgreSQL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#website\",\"url\":\"https:\/\/test.opensource-db.in\/wp1\/\",\"name\":\"OpenSource DB\",\"description\":\"Your Trusted OpenSource Databases partner\",\"publisher\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/test.opensource-db.in\/wp1\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#organization\",\"name\":\"OPENSOURCE DB PRIVATE LIMITED\",\"url\":\"https:\/\/test.opensource-db.in\/wp1\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2021\/10\/osdb-logo-tm-2.png\",\"contentUrl\":\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2021\/10\/osdb-logo-tm-2.png\",\"width\":368,\"height\":120,\"caption\":\"OPENSOURCE DB PRIVATE LIMITED\"},\"image\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/people\/OpenSource-DB\/100072970755470\/\",\"https:\/\/x.com\/opensource_db\",\"https:\/\/www.youtube.com\/channel\/UCmTI5h\",\"https:\/\/www.linkedin.com\/company\/opensource-db\",\"https:\/\/www.instagram.com\/opensource_db\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/person\/422480fbefed0b2cee82aeab232110f5\",\"name\":\"Shameer Bhupathi\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/2cfa95999202132ded07acd24f6faf25dca145a6c3efe47919204f115ffbf625?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/2cfa95999202132ded07acd24f6faf25dca145a6c3efe47919204f115ffbf625?s=96&d=mm&r=g\",\"caption\":\"Shameer Bhupathi\"},\"url\":\"https:\/\/test.opensource-db.in\/wp1\/author\/shameer-bhupathi\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Mastering the pg_settings view in PostgreSQL - OpenSource DB","robots":{"index":"noindex","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"og_locale":"en_US","og_type":"article","og_title":"Mastering the pg_settings view in PostgreSQL - OpenSource DB","og_description":"Introduction PostgreSQL, a powerful and highly customizable open-source relational database system, offers a wide range of tools to manage and [&hellip;]","og_url":"https:\/\/test.opensource-db.in\/wp1\/mastering-the-pg_settings-view-in-postgresql\/","og_site_name":"OpenSource DB","article_publisher":"https:\/\/www.facebook.com\/people\/OpenSource-DB\/100072970755470\/","article_published_time":"2024-12-26T11:34:32+00:00","article_modified_time":"2024-12-26T11:38:10+00:00","og_image":[{"width":1800,"height":945,"url":"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/12\/image-15.png","type":"image\/png"}],"author":"Shameer Bhupathi","twitter_card":"summary_large_image","twitter_creator":"@opensource_db","twitter_site":"@opensource_db","twitter_misc":{"Written by":"Shameer Bhupathi","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/test.opensource-db.in\/wp1\/mastering-the-pg_settings-view-in-postgresql\/#article","isPartOf":{"@id":"https:\/\/test.opensource-db.in\/wp1\/mastering-the-pg_settings-view-in-postgresql\/"},"author":{"name":"Shameer Bhupathi","@id":"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/person\/422480fbefed0b2cee82aeab232110f5"},"headline":"Mastering the pg_settings view in PostgreSQL","datePublished":"2024-12-26T11:34:32+00:00","dateModified":"2024-12-26T11:38:10+00:00","mainEntityOfPage":{"@id":"https:\/\/test.opensource-db.in\/wp1\/mastering-the-pg_settings-view-in-postgresql\/"},"wordCount":777,"commentCount":0,"publisher":{"@id":"https:\/\/test.opensource-db.in\/wp1\/#organization"},"image":{"@id":"https:\/\/test.opensource-db.in\/wp1\/mastering-the-pg_settings-view-in-postgresql\/#primaryimage"},"thumbnailUrl":"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/12\/image-15.png","articleSection":["Others","PostgreSQL 14","PostgreSQL 15","PostgreSQL 16"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/test.opensource-db.in\/wp1\/mastering-the-pg_settings-view-in-postgresql\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/test.opensource-db.in\/wp1\/mastering-the-pg_settings-view-in-postgresql\/","url":"https:\/\/test.opensource-db.in\/wp1\/mastering-the-pg_settings-view-in-postgresql\/","name":"Mastering the pg_settings view in PostgreSQL - OpenSource DB","isPartOf":{"@id":"https:\/\/test.opensource-db.in\/wp1\/#website"},"primaryImageOfPage":{"@id":"https:\/\/test.opensource-db.in\/wp1\/mastering-the-pg_settings-view-in-postgresql\/#primaryimage"},"image":{"@id":"https:\/\/test.opensource-db.in\/wp1\/mastering-the-pg_settings-view-in-postgresql\/#primaryimage"},"thumbnailUrl":"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/12\/image-15.png","datePublished":"2024-12-26T11:34:32+00:00","dateModified":"2024-12-26T11:38:10+00:00","breadcrumb":{"@id":"https:\/\/test.opensource-db.in\/wp1\/mastering-the-pg_settings-view-in-postgresql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/test.opensource-db.in\/wp1\/mastering-the-pg_settings-view-in-postgresql\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/test.opensource-db.in\/wp1\/mastering-the-pg_settings-view-in-postgresql\/#primaryimage","url":"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/12\/image-15.png","contentUrl":"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/12\/image-15.png","width":1800,"height":945},{"@type":"BreadcrumbList","@id":"https:\/\/test.opensource-db.in\/wp1\/mastering-the-pg_settings-view-in-postgresql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/test.opensource-db.in\/wp1\/"},{"@type":"ListItem","position":2,"name":"Mastering the pg_settings view in PostgreSQL"}]},{"@type":"WebSite","@id":"https:\/\/test.opensource-db.in\/wp1\/#website","url":"https:\/\/test.opensource-db.in\/wp1\/","name":"OpenSource DB","description":"Your Trusted OpenSource Databases partner","publisher":{"@id":"https:\/\/test.opensource-db.in\/wp1\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/test.opensource-db.in\/wp1\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/test.opensource-db.in\/wp1\/#organization","name":"OPENSOURCE DB PRIVATE LIMITED","url":"https:\/\/test.opensource-db.in\/wp1\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/logo\/image\/","url":"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2021\/10\/osdb-logo-tm-2.png","contentUrl":"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2021\/10\/osdb-logo-tm-2.png","width":368,"height":120,"caption":"OPENSOURCE DB PRIVATE LIMITED"},"image":{"@id":"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/people\/OpenSource-DB\/100072970755470\/","https:\/\/x.com\/opensource_db","https:\/\/www.youtube.com\/channel\/UCmTI5h","https:\/\/www.linkedin.com\/company\/opensource-db","https:\/\/www.instagram.com\/opensource_db\/"]},{"@type":"Person","@id":"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/person\/422480fbefed0b2cee82aeab232110f5","name":"Shameer Bhupathi","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/2cfa95999202132ded07acd24f6faf25dca145a6c3efe47919204f115ffbf625?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/2cfa95999202132ded07acd24f6faf25dca145a6c3efe47919204f115ffbf625?s=96&d=mm&r=g","caption":"Shameer Bhupathi"},"url":"https:\/\/test.opensource-db.in\/wp1\/author\/shameer-bhupathi\/"}]}},"rttpg_featured_image_url":{"full":["https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/12\/image-15.png",1800,945,false],"landscape":["https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/12\/image-15.png",1800,945,false],"portraits":["https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/12\/image-15.png",1800,945,false],"thumbnail":["https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/12\/image-15-150x150.png",150,150,true],"medium":["https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/12\/image-15-300x158.png",300,158,true],"large":["https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/12\/image-15-1024x538.png",1024,538,true],"1536x1536":["https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/12\/image-15-1536x806.png",1536,806,true],"2048x2048":["https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/12\/image-15.png",1800,945,false],"ultp_layout_landscape_large":["https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/12\/image-15.png",1200,630,false],"ultp_layout_landscape":["https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/12\/image-15.png",870,457,false],"ultp_layout_portrait":["https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/12\/image-15.png",600,315,false],"ultp_layout_square":["https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/12\/image-15.png",600,315,false]},"rttpg_author":{"display_name":"Shameer Bhupathi","author_link":"https:\/\/test.opensource-db.in\/wp1\/author\/shameer-bhupathi\/"},"rttpg_comment":0,"rttpg_category":"<a href=\"https:\/\/test.opensource-db.in\/wp1\/category\/business\/others\/\" rel=\"category tag\">Others<\/a> <a href=\"https:\/\/test.opensource-db.in\/wp1\/category\/postgres\/postgresql-14\/\" rel=\"category tag\">PostgreSQL 14<\/a> <a href=\"https:\/\/test.opensource-db.in\/wp1\/category\/postgres\/postgresql-15\/\" rel=\"category tag\">PostgreSQL 15<\/a> <a href=\"https:\/\/test.opensource-db.in\/wp1\/category\/postgres\/postgresql-16\/\" rel=\"category tag\">PostgreSQL 16<\/a>","rttpg_excerpt":"Introduction PostgreSQL, a powerful and highly customizable open-source relational database system, offers a wide range of tools to manage and [&hellip;]","_links":{"self":[{"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/posts\/6664","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/users\/13"}],"replies":[{"embeddable":true,"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/comments?post=6664"}],"version-history":[{"count":12,"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/posts\/6664\/revisions"}],"predecessor-version":[{"id":6684,"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/posts\/6664\/revisions\/6684"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/media\/6683"}],"wp:attachment":[{"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/media?parent=6664"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/categories?post=6664"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/tags?post=6664"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}