{"id":346,"date":"2022-05-21T07:17:20","date_gmt":"2022-05-21T05:17:20","guid":{"rendered":"https:\/\/ptdb.ch\/?p=346"},"modified":"2022-05-21T07:17:20","modified_gmt":"2022-05-21T05:17:20","slug":"postgresql-temboard-version-7-11-released-with-huge-performance-boost","status":"publish","type":"post","link":"https:\/\/ptdb.ch\/?p=346","title":{"rendered":"PostgreSQL: temBoard version 7.11 released with huge performance boost"},"content":{"rendered":"<p>Dalibo released temBoard version 7.11 on the 18.05.2022, which is quite an important release because it comes with a huge performance boost. Besides that, a lot of bugfixes went into this release as well. The most important changes in release 7.11 can be found on the temBoards documentation page.<\/p>\n<p><a href=\"https:\/\/temboard.readthedocs.io\/en\/v7\/CHANGELOG\/\">https:\/\/temboard.readthedocs.io\/en\/v7\/CHANGELOG\/<\/a><\/p>\n<p>[7.11]<\/p>\n<ul>\n<li>Fix heap bloat probe.<\/li>\n<li>Fix statements not purged.<\/li>\n<li>Collect metrics by agent batch. Huge performance boost.<\/li>\n<li>Log HTTP request response time.<\/li>\n<li>Check agent key on registration.<\/li>\n<li>docker: New tag 7 for stable branch.<\/li>\n<li>docker: Reduce image size using multi-stage build.<\/li>\n<\/ul>\n<p>Agent:<\/p>\n<ul>\n<li>docker: Fix build.<\/li>\n<li>docker: Properly stop container on failure.<\/li>\n<\/ul>\n<p>[7.10]<\/p>\n<ul>\n<li>Fix performances issues with monitoring.<\/li>\n<li>Show runtime libpq version in logs and &#8211;version.<\/li>\n<li>Authenticate with agent using both header and query arg. 8.0 will remove query arg auth.<\/li>\n<li>Packages for bullseye for both UI and agent.<\/li>\n<li>Drop jessie package.<\/li>\n<li>Always set application_name.<\/li>\n<\/ul>\n<p>Server:<\/p>\n<ul>\n<li>Fix database ownership on creation.<\/li>\n<li>Fix first collector run failure on new agent.<\/li>\n<li>Fix tracebacks when an agent is down.<\/li>\n<li>Fix &#8216;null&#8217; instance comment with auto register.<\/li>\n<li>Ship a \/usr\/share\/temboard\/sql\/reassign.sql script to fix ownership.<\/li>\n<li>Define a shell to temboard UNIX user.<\/li>\n<li>Review defaults temBoard user groups.<\/li>\n<li>Optionnal performance tracing in temBoard UI logs.<\/li>\n<li>Moving to Python3 on stretch, buster and bullseye.<\/li>\n<li>Drop another tooltip breaking dropdown menu.<\/li>\n<li>Monitoring: Time SQL queries for archive and aggregation.<\/li>\n<li>systemctl reload temboard now reload temBoard configuration.<\/li>\n<\/ul>\n<p>Agent:<\/p>\n<ul>\n<li>Fix database probes always executed on same database.<\/li>\n<li>Reduce reconnexion in monitoring probes.<\/li>\n<li>Explicitily requires psycopg2 2.7+ on debian.<\/li>\n<li>Ignore loopback and tmpfs file systems.<\/li>\n<li>Drop Python2 support<\/li>\n<li>Build RHEL8 package with RockyLinux 8.<\/li>\n<\/ul>\n<p>In case you are interested in the complete list of changes between version 7.9 and 7.11 I would recommended to use the Github compare.<\/p>\n<p><a href=\"https:\/\/github.com\/dalibo\/temboard\/compare\/7.9...7.11\">https:\/\/github.com\/dalibo\/temboard\/compare\/7.9&#8230;7.11<\/a><\/p>\n<p>The latest version for Red Hat\/CentOS 7.x can be found here:<\/p>\n<p><a href=\"https:\/\/yum.dalibo.org\/labs\/CentOS7-x86_64\/\">https:\/\/yum.dalibo.org\/labs\/CentOS7-x86_64\/<\/a><\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\ntemboard-7.11-1.el7.noarch.rpm\ntemboard-agent-7.11-1.el7.noarch.rpm\n<\/pre>\n<p>Fortunately, the upgrade from 7.9 to 7.11 is quite simply. In general, you need only to stop the service, upgrade the rpm package, run the temboard-migratedb script and start the service again.<\/p>\n<p>Stop the temBoard server and agent and start with a clean log file.<\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\n$ sudo systemctl stop temboard.service\n$ sudo systemctl stop temboard-agent@12-pg58888.service\n$ sudo systemctl reset-failed\n$ sudo systemctl is-system-running\nrunning\n\n$ cd \/var\/log\/temboard\/\n$ sudo mv temboard.log temboard.log.before_upgrade_to_7.11\n$\n<\/pre>\n<p>Upgrade the temBoard (UI) to 7.11<\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\n$ sudo yum localupdate temboard-7.11-1.el7.noarch.rpm\nLoaded plugins: enabled_repos_upload, langpacks, package_upload, product-id, search-disabled-repos, subscription-manager\nExamining temboard-7.11-1.el7.noarch.rpm: temboard-7.11-1.el7.noarch\nMarking temboard-7.11-1.el7.noarch.rpm as an update to temboard-7.10-1.el7.noarch\nResolving Dependencies\n--&gt; Running transaction check\n---&gt; Package temboard.noarch 0:7.10-1.el7 will be updated\n---&gt; Package temboard.noarch 0:7.11-1.el7 will be an update\n--&gt; Finished Dependency Resolution\nrhel-7-server-extras-rpms\/x86_64                                                                                        | 2.0 kB  00:00:00\nrhel-7-server-optional-rpms\/x86_64                                                                                      | 2.0 kB  00:00:00\nrhel-7-server-rh-common-rpms\/x86_64                                                                                     | 2.1 kB  00:00:00\nrhel-7-server-rpms\/x86_64                                                                                               | 2.0 kB  00:00:00\nrhel-7-server-satellite-tools-6.9-rpms\/x86_64                                                                           | 2.1 kB  00:00:00\nrhel-7-server-supplementary-rpms\/x86_64                                                                                 | 2.3 kB  00:00:00\nrhel-server-rhscl-7-rpms\/x86_64                                                                                         | 2.3 kB  00:00:00\n\nDependencies Resolved\n\n===============================================================================================================================================\n Package                      Arch                       Version                         Repository                                       Size\n===============================================================================================================================================\nUpdating:\n temboard                     noarch                     7.11-1.el7                      \/temboard-7.11-1.el7.noarch                     3.9 M\n\nTransaction Summary\n===============================================================================================================================================\nUpgrade  1 Package\n\nTotal size: 3.9 M\nIs this ok &#x5B;y\/d\/N]: y\nDownloading packages:\nRunning transaction check\nRunning transaction test\nTransaction test succeeded\nRunning transaction\n  Updating   : temboard-7.11-1.el7.noarch                                                                                                  1\/2\n  Cleanup    : temboard-7.10-1.el7.noarch                                                                                                  2\/2\nUploading Package Profile\nLoaded plugins: langpacks, product-id, subscription-manager\n  Verifying  : temboard-7.11-1.el7.noarch                                                                                                  1\/2\n  Verifying  : temboard-7.10-1.el7.noarch                                                                                                  2\/2\n\nUpdated:\n  temboard.noarch 0:7.11-1.el7\n\nComplete!\nUploading Enabled Repositories Report\nLoaded plugins: langpacks, product-id, subscription-manager\n\n\nCheck if the new version is correct.\n\n&#x5B;sourcecode language=&quot;plain&quot;]\n$ temboard --version\n INFO: Starting temboard 7.11.\ntemBoard 7.11\nSystem Red Hat Enterprise Linux Server 7.9 (Maipo)\nPython 2.7.5 (\/usr\/bin\/python)\nTornado 4.2.1\npsycopg2 2.5.1 (dt dec pq3 ext)\nlibpq 9.2.24\nSQLAlchemy 0.9.8\nalembic 0.8.3\n<\/pre>\n<p>Upgrade the temBoard agent.<\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\n$ sudo yum localupdate temboard-agent-7.11-1.el7.noarch.rpm\nLoaded plugins: enabled_repos_upload, langpacks, package_upload, product-id, search-disabled-repos, subscription-manager\nExamining temboard-agent-7.11-1.el7.noarch.rpm: temboard-agent-7.11-1.el7.noarch\nMarking temboard-agent-7.11-1.el7.noarch.rpm as an update to temboard-agent-7.10-1.el7.noarch\nResolving Dependencies\n--&gt; Running transaction check\n---&gt; Package temboard-agent.noarch 0:7.10-1.el7 will be updated\n---&gt; Package temboard-agent.noarch 0:7.11-1.el7 will be an update\n--&gt; Finished Dependency Resolution\nrhel-7-server-extras-rpms\/x86_64                                                                                        | 2.0 kB  00:00:00\nrhel-7-server-optional-rpms\/x86_64                                                                                      | 2.0 kB  00:00:00\nrhel-7-server-rh-common-rpms\/x86_64                                                                                     | 2.1 kB  00:00:00\nrhel-7-server-rpms\/x86_64                                                                                               | 2.0 kB  00:00:00\nrhel-7-server-satellite-tools-6.9-rpms\/x86_64                                                                           | 2.1 kB  00:00:00\nrhel-7-server-supplementary-rpms\/x86_64                                                                                 | 2.3 kB  00:00:00\nrhel-server-rhscl-7-rpms\/x86_64                                                                                         | 2.3 kB  00:00:00\n\nDependencies Resolved\n\n===============================================================================================================================================\n Package                         Arch                    Version                      Repository                                          Size\n===============================================================================================================================================\nUpdating:\n temboard-agent                  noarch                  7.11-1.el7                   \/temboard-agent-7.11-1.el7.noarch                  900 k\n\nTransaction Summary\n===============================================================================================================================================\nUpgrade  1 Package\n\nTotal size: 900 k\nIs this ok &#x5B;y\/d\/N]: y\nDownloading packages:\nRunning transaction check\nRunning transaction test\nTransaction test succeeded\nRunning transaction\n  Updating   : temboard-agent-7.11-1.el7.noarch                                                                                            1\/2\nNo units found for temboard-agent.\nToo few arguments.\n  Cleanup    : temboard-agent-7.10-1.el7.noarch                                                                                            2\/2\nUploading Package Profile\nLoaded plugins: langpacks, product-id, subscription-manager\n  Verifying  : temboard-agent-7.11-1.el7.noarch                                                                                            1\/2\n  Verifying  : temboard-agent-7.10-1.el7.noarch                                                                                            2\/2\n\nUpdated:\n  temboard-agent.noarch 0:7.11-1.el7\n\nComplete!\nUploading Enabled Repositories Report\nLoaded plugins: langpacks, product-id, subscription-manager\n<\/pre>\n<p>Check if the new agent version is correct.<\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\n$ temboard-agent --version\n INFO: Starting temboard-agent 7.11.\ntemBoard agent 7.11\nSystem Red Hat Enterprise Linux Server 7.9 (Maipo)\nPython 3.6.8 (\/usr\/bin\/python3)\npsycopg2 2.7.7 (dt dec pq3 ext) libpq 9.2.24\n<\/pre>\n<p>Now run the database upgrade as the temboard OS user.<\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\n$ su - temboard\nPassword:\nLast login: Wed Feb 23 08:13:38 CET 2022 on pts\/1\n\n$ temboard-migratedb upgrade\n INFO: Starting temboard-migratedb 7.11.\n INFO: Found config file \/etc\/temboard\/temboard.conf.\n INFO: Running on Red Hat Enterprise Linux Server 7.9 (Maipo).\n INFO: Using Python 2.7.5 (\/usr\/bin\/python) and Tornado 4.2.1.\n INFO: Using libpq 9.2.24, Psycopg2 2.5.1 (dt dec pq3 ext) and SQLAlchemy 0.9.8.\n INFO: Context impl PostgresqlImpl.\n INFO: Will assume transactional DDL.\n INFO: Database up to date.\n\n$\n<\/pre>\n<p>You might will notice that a few entries in the PostgreSQL repository database.<\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\n2022-05-19 10:35:10.546 CEST &#x5B;28573] LOG:  statement: CREATE SCHEMA IF NOT EXISTS &quot;application&quot;;\n2022-05-19 10:35:10.548 CEST &#x5B;28573] LOG:  statement: ALTER TABLE public.alembic_version SET SCHEMA &quot;application&quot;;\n2022-05-19 10:35:10.549 CEST &#x5B;28573] ERROR:  relation &quot;public.alembic_version&quot; does not exist\n2022-05-19 10:35:10.549 CEST &#x5B;28573] STATEMENT:  ALTER TABLE public.alembic_version SET SCHEMA &quot;application&quot;;\n2022-05-19 10:35:45.947 CEST &#x5B;2136] LOG:  checkpoint starting: time\n<\/pre>\n<p>Add the Environment to the service file of tembaord server and agent.<\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nEnvironment=&quot;LD_LIBRARY_PATH=\/app\/lib\/postgres\/pgproduct\/pg-12.10\/lib&quot;\n<\/pre>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\n$ sudo vi temboard-agent@12-pg58888.service\n$ sudo vi temboard.service\n$ cat temboard-agent@12-pg58888.service\n&#x5B;Unit]\nDescription=PostgreSQL Remote Control Agent %I\nAfter=network.target postgresql@%i.service\nAssertPathExists=\/etc\/temboard-agent\/%I\/temboard-agent.conf\n\n&#x5B;Service]\nType=simple\nUser=postgres\nGroup=postgres\nEnvironment=&quot;LD_LIBRARY_PATH=\/app\/lib\/postgres\/pgproduct\/pg-12.10\/lib&quot;\nExecStart=\/usr\/bin\/env SYSTEMD=1 temboard-agent -c \/etc\/temboard-agent\/%I\/temboard-agent.conf\n\n&#x5B;Install]\nWantedBy=multi-user.target\n\n\n$ cat temboard.service\n&#x5B;Unit]\nDescription=temBoard Web UI\nAfter=network.target\n\n&#x5B;Service]\nType=simple\nUser=temboard\nGroup=temboard\nEnvironment=&quot;LD_LIBRARY_PATH=\/app\/lib\/postgres\/pgproduct\/pg-12.10\/lib&quot;\nExecStart=\/usr\/bin\/env SYSTEMD=1 temboard -c \/etc\/temboard\/temboard.conf\nExecReload=kill -HUP $MAINPID\n\n&#x5B;Install]\nWantedBy=multi-user.target\n\n\n$ sudo systemctl daemon-reload\n$ sudo systemctl reset-failed\n$ sudo systemctl is-system-running\nrunning\n<\/pre>\n<p>I usually adjust the temboard service as well with the nice value of -19. (Nice=-19). This is an optional step and not mandatory. I do it only to give the temBoard service the highest CPU priority.<\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\n$ cd \/etc\/systemd\/system\/temboard.service.d\/\n$ cat override.conf\n&#x5B;Service]\nNice=-19\n#Environment=PERF=y\n<\/pre>\n<p>Startup the temBoard UI and the agent.<\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\n$ sudo systemctl daemon-reload\n$ sudo systemctl start temboard.service\n$ sudo systemctl start temboard-agent@12-pg58888.service\n<\/pre>\n<p>Check if the services are running correctly.<\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\n\n$ sudo systemctl status temboard.service\n\u25cf temboard.service - temBoard Web UI\n   Loaded: loaded (\/usr\/lib\/systemd\/system\/temboard.service; enabled; vendor preset: disabled)\n  Drop-In: \/etc\/systemd\/system\/temboard.service.d\n           \u2514\u2500override.conf\n   Active: active (running) since Thu 2022-05-19 10:43:25 CEST; 36s ago\n Main PID: 14459 (temboard)\n   CGroup: \/system.slice\/temboard.service\n           \u251c\u250014459 temboard: web\n           \u251c\u250014467 temboard: worker pool\n           \u251c\u250014468 temboard: scheduler\n           \u251c\u250014480 temboard: task temboardui.plugins.statements.statements_purge_wo\n           \u251c\u250014482 temboard: task temboardui.plugins.statements.pull_data_worker\n           \u251c\u250014495 temboard: task temboardui.plugins.monitoring.collector_batch\n           \u251c\u250014496 temboard: task temboardui.plugins.monitoring.collector_batch\n           \u251c\u250014497 temboard: task temboardui.plugins.monitoring.collector_batch\n           \u251c\u250014498 temboard: task temboardui.plugins.monitoring.collector_batch\n           \u251c\u250014499 temboard: task temboardui.plugins.monitoring.collector_batch\n           \u251c\u250014500 temboard: task temboardui.plugins.monitoring.collector_batch\n           \u251c\u250014501 temboard: task temboardui.plugins.monitoring.collector_batch\n           \u251c\u250014505 temboard: task temboardui.plugins.monitoring.collector_batch\n           \u251c\u250014509 temboard: task temboardui.plugins.monitoring.collector_batch\n           \u251c\u250014517 temboard: task temboardui.plugins.monitoring.collector_batch\n           \u251c\u250014519 temboard: task temboardui.plugins.monitoring.collector_batch\n           \u251c\u250014524 temboard: task temboardui.plugins.monitoring.collector_batch\n           \u251c\u250014525 temboard: task temboardui.plugins.monitoring.collector_batch\n           \u251c\u250014528 temboard: task temboardui.plugins.monitoring.collector_batch\n           \u251c\u250014529 temboard: task temboardui.plugins.monitoring.collector_batch\n           \u251c\u250014530 temboard: task temboardui.plugins.monitoring.collector_batch\n           \u2514\u250015668 temboard: task temboardui.plugins.monitoring.notify_state_change\n\n\n\n\n$ sudo systemctl status temboard-agent@12-pg58888.service\n\u25cf temboard-agent@12-pg58888.service - PostgreSQL Remote Control Agent 12\/pg58888\n   Loaded: loaded (\/usr\/lib\/systemd\/system\/temboard-agent@.service; enabled; vendor preset: disabled)\n   Active: active (running) since Thu 2022-05-19 10:43:41 CEST; 37s ago\n Main PID: 14905 (temboard-agent)\n   CGroup: \/system.slice\/system-temboard\\x2dagent.slice\/temboard-agent@12-pg58888.service\n           \u251c\u250014905 temboard-agent: 12\/pg58888: main process\n           \u251c\u250014932 temboard-agent: 12\/pg58888: worker pool\n           \u2514\u250014933 temboard-agent: 12\/pg58888: scheduler\n\nMay 19 10:43:41 host01 systemd&#x5B;1]: Started PostgreSQL Remote Control Agent 12\/pg58888.\nMay 19 10:43:41 host01 env&#x5B;14905]: INFO: Starting temboard-agent 7.11.\nMay 19 10:43:41 host01 env&#x5B;14905]: INFO: Running on Red Hat Enterprise Linux Server 7.9 (Maipo).\nMay 19 10:43:41 host01 env&#x5B;14905]: INFO: Using Python 3.6.8 (\/usr\/bin\/python3).\nMay 19 10:43:41 host01 env&#x5B;14905]: INFO: Using libpq 12.10, Psycopg2 2.7.7 (dt dec pq3 ext).\n<\/pre>\n<p>Ready \ud83d\ude42<\/p>\n<h3>Conclusion<\/h3>\n<p>The temBoard 7.11 is very important new release which comes with a lot of bug fixes and huge performance benefits.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Dalibo released temBoard version 7.11 on the 18.05.2022, which is quite an important release because it comes with a huge performance boost. Besides that, a lot of bugfixes went into this release as well. The most important changes in release 7.11 can be found on the temBoards documentation page. https:\/\/temboard.readthedocs.io\/en\/v7\/CHANGELOG\/ [7.11] Fix heap bloat probe. [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ocean_post_layout":"","ocean_both_sidebars_style":"","ocean_both_sidebars_content_width":0,"ocean_both_sidebars_sidebars_width":0,"ocean_sidebar":"","ocean_second_sidebar":"","ocean_disable_margins":"enable","ocean_add_body_class":"","ocean_shortcode_before_top_bar":"","ocean_shortcode_after_top_bar":"","ocean_shortcode_before_header":"","ocean_shortcode_after_header":"","ocean_has_shortcode":"","ocean_shortcode_after_title":"","ocean_shortcode_before_footer_widgets":"","ocean_shortcode_after_footer_widgets":"","ocean_shortcode_before_footer_bottom":"","ocean_shortcode_after_footer_bottom":"","ocean_display_top_bar":"default","ocean_display_header":"default","ocean_header_style":"","ocean_center_header_left_menu":"","ocean_custom_header_template":"","ocean_custom_logo":0,"ocean_custom_retina_logo":0,"ocean_custom_logo_max_width":0,"ocean_custom_logo_tablet_max_width":0,"ocean_custom_logo_mobile_max_width":0,"ocean_custom_logo_max_height":0,"ocean_custom_logo_tablet_max_height":0,"ocean_custom_logo_mobile_max_height":0,"ocean_header_custom_menu":"","ocean_menu_typo_font_family":"","ocean_menu_typo_font_subset":"","ocean_menu_typo_font_size":0,"ocean_menu_typo_font_size_tablet":0,"ocean_menu_typo_font_size_mobile":0,"ocean_menu_typo_font_size_unit":"px","ocean_menu_typo_font_weight":"","ocean_menu_typo_font_weight_tablet":"","ocean_menu_typo_font_weight_mobile":"","ocean_menu_typo_transform":"","ocean_menu_typo_transform_tablet":"","ocean_menu_typo_transform_mobile":"","ocean_menu_typo_line_height":0,"ocean_menu_typo_line_height_tablet":0,"ocean_menu_typo_line_height_mobile":0,"ocean_menu_typo_line_height_unit":"","ocean_menu_typo_spacing":0,"ocean_menu_typo_spacing_tablet":0,"ocean_menu_typo_spacing_mobile":0,"ocean_menu_typo_spacing_unit":"","ocean_menu_link_color":"","ocean_menu_link_color_hover":"","ocean_menu_link_color_active":"","ocean_menu_link_background":"","ocean_menu_link_hover_background":"","ocean_menu_link_active_background":"","ocean_menu_social_links_bg":"","ocean_menu_social_hover_links_bg":"","ocean_menu_social_links_color":"","ocean_menu_social_hover_links_color":"","ocean_disable_title":"default","ocean_disable_heading":"default","ocean_post_title":"","ocean_post_subheading":"","ocean_post_title_style":"","ocean_post_title_background_color":"","ocean_post_title_background":0,"ocean_post_title_bg_image_position":"","ocean_post_title_bg_image_attachment":"","ocean_post_title_bg_image_repeat":"","ocean_post_title_bg_image_size":"","ocean_post_title_height":0,"ocean_post_title_bg_overlay":0.5,"ocean_post_title_bg_overlay_color":"","ocean_disable_breadcrumbs":"default","ocean_breadcrumbs_color":"","ocean_breadcrumbs_separator_color":"","ocean_breadcrumbs_links_color":"","ocean_breadcrumbs_links_hover_color":"","ocean_display_footer_widgets":"default","ocean_display_footer_bottom":"default","ocean_custom_footer_template":"","ocean_post_oembed":"","ocean_post_self_hosted_media":"","ocean_post_video_embed":"","ocean_link_format":"","ocean_link_format_target":"self","ocean_quote_format":"","ocean_quote_format_link":"post","ocean_gallery_link_images":"on","ocean_gallery_id":[],"footnotes":""},"categories":[10,2,5,6,7],"tags":[17,21,24],"class_list":["post-346","post","type-post","status-publish","format-standard","hentry","category-centos-os","category-db","category-os","category-postgresql","category-red-hat","tag-monitoring","tag-postgresql","tag-temboard","entry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.6 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>PostgreSQL: temBoard version 7.11 released with huge performance boost - ptdb - Platinum DB<\/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:\/\/ptdb.ch\/?p=346\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"PostgreSQL: temBoard version 7.11 released with huge performance boost - ptdb - Platinum DB\" \/>\n<meta property=\"og:description\" content=\"Dalibo released temBoard version 7.11 on the 18.05.2022, which is quite an important release because it comes with a huge performance boost. Besides that, a lot of bugfixes went into this release as well. The most important changes in release 7.11 can be found on the temBoards documentation page. https:\/\/temboard.readthedocs.io\/en\/v7\/CHANGELOG\/ [7.11] Fix heap bloat probe. [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/ptdb.ch\/?p=346\" \/>\n<meta property=\"og:site_name\" content=\"ptdb - Platinum DB\" \/>\n<meta property=\"article:published_time\" content=\"2022-05-21T05:17:20+00:00\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"8 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/ptdb.ch\/?p=346\",\"url\":\"https:\/\/ptdb.ch\/?p=346\",\"name\":\"PostgreSQL: temBoard version 7.11 released with huge performance boost - ptdb - Platinum DB\",\"isPartOf\":{\"@id\":\"https:\/\/ptdb.ch\/#website\"},\"datePublished\":\"2022-05-21T05:17:20+00:00\",\"author\":{\"@id\":\"https:\/\/ptdb.ch\/#\/schema\/person\/0b7baf52d23e71d85e1c95442306090b\"},\"breadcrumb\":{\"@id\":\"https:\/\/ptdb.ch\/?p=346#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/ptdb.ch\/?p=346\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/ptdb.ch\/?p=346#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/ptdb.ch\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"PostgreSQL: temBoard version 7.11 released with huge performance boost\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/ptdb.ch\/#website\",\"url\":\"https:\/\/ptdb.ch\/\",\"name\":\"ptdb - Platinum DB\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/ptdb.ch\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/ptdb.ch\/#\/schema\/person\/0b7baf52d23e71d85e1c95442306090b\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/ptdb.ch\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/1a3dffc48c5f6bae0b88a9f0b2a986d48d322673fbc2880c5abbfab96e45da8a?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/1a3dffc48c5f6bae0b88a9f0b2a986d48d322673fbc2880c5abbfab96e45da8a?s=96&d=mm&r=g\",\"caption\":\"admin\"},\"sameAs\":[\"https:\/\/ptdb.ch\"],\"url\":\"https:\/\/ptdb.ch\/?author=1\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"PostgreSQL: temBoard version 7.11 released with huge performance boost - ptdb - Platinum DB","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:\/\/ptdb.ch\/?p=346","og_locale":"en_US","og_type":"article","og_title":"PostgreSQL: temBoard version 7.11 released with huge performance boost - ptdb - Platinum DB","og_description":"Dalibo released temBoard version 7.11 on the 18.05.2022, which is quite an important release because it comes with a huge performance boost. Besides that, a lot of bugfixes went into this release as well. The most important changes in release 7.11 can be found on the temBoards documentation page. https:\/\/temboard.readthedocs.io\/en\/v7\/CHANGELOG\/ [7.11] Fix heap bloat probe. [&hellip;]","og_url":"https:\/\/ptdb.ch\/?p=346","og_site_name":"ptdb - Platinum DB","article_published_time":"2022-05-21T05:17:20+00:00","author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"admin","Est. reading time":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/ptdb.ch\/?p=346","url":"https:\/\/ptdb.ch\/?p=346","name":"PostgreSQL: temBoard version 7.11 released with huge performance boost - ptdb - Platinum DB","isPartOf":{"@id":"https:\/\/ptdb.ch\/#website"},"datePublished":"2022-05-21T05:17:20+00:00","author":{"@id":"https:\/\/ptdb.ch\/#\/schema\/person\/0b7baf52d23e71d85e1c95442306090b"},"breadcrumb":{"@id":"https:\/\/ptdb.ch\/?p=346#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/ptdb.ch\/?p=346"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/ptdb.ch\/?p=346#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/ptdb.ch\/"},{"@type":"ListItem","position":2,"name":"PostgreSQL: temBoard version 7.11 released with huge performance boost"}]},{"@type":"WebSite","@id":"https:\/\/ptdb.ch\/#website","url":"https:\/\/ptdb.ch\/","name":"ptdb - Platinum DB","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/ptdb.ch\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/ptdb.ch\/#\/schema\/person\/0b7baf52d23e71d85e1c95442306090b","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/ptdb.ch\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/1a3dffc48c5f6bae0b88a9f0b2a986d48d322673fbc2880c5abbfab96e45da8a?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1a3dffc48c5f6bae0b88a9f0b2a986d48d322673fbc2880c5abbfab96e45da8a?s=96&d=mm&r=g","caption":"admin"},"sameAs":["https:\/\/ptdb.ch"],"url":"https:\/\/ptdb.ch\/?author=1"}]}},"_links":{"self":[{"href":"https:\/\/ptdb.ch\/index.php?rest_route=\/wp\/v2\/posts\/346","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ptdb.ch\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ptdb.ch\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ptdb.ch\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ptdb.ch\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=346"}],"version-history":[{"count":0,"href":"https:\/\/ptdb.ch\/index.php?rest_route=\/wp\/v2\/posts\/346\/revisions"}],"wp:attachment":[{"href":"https:\/\/ptdb.ch\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=346"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ptdb.ch\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=346"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ptdb.ch\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=346"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}