{"id":1382,"date":"2019-04-25T00:00:00","date_gmt":"2019-04-25T00:00:00","guid":{"rendered":""},"modified":"2025-06-20T12:58:20","modified_gmt":"2025-06-20T19:58:20","slug":"optimize-performance-using-azure-database-for-postgresql-recommendations","status":"publish","type":"post","link":"https:\/\/azure.microsoft.com\/en-us\/blog\/optimize-performance-using-azure-database-for-postgresql-recommendations\/","title":{"rendered":"Optimize performance using Azure Database for PostgreSQL Recommendations"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">As a developer today, you have a lot of things to worry about. There are new technologies, frameworks, and deployment models that you need to keep up with so that you can build game-changing apps for customers. At the end of the day though, one thing that remains unchanged is the need to focus on developing features that add value while ensuring that your database remains functional and performant. In the past, a DBA would take care of your database performance, but today that responsibility can be shared across many roles.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">You no longer have to be a database expert to optimize your database. Make your job easier and start taking advantage of&nbsp;Azure Database for PostgreSQL Recommendation for <a href=\"https:\/\/azure.microsoft.com\/en-us\/services\/postgresql\/\" target=\"_blank\" rel=\"noopener\">Azure Database for PostgreSQL today.<\/a><\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"analyzing-workloads-making-recommendations\">Analyzing workloads + making recommendations =<img loading=\"lazy\" decoding=\"async\" title=\"heart\" width=\"23\" height=\"23\" style=\"color: revert;font-family: inherit;font-size: 2.3125rem\" src=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2019\/04\/heart.webp\" alt=\"heart\"><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">By analyzing the workloads on your server, the recommendations feature gives you daily insights about the Azure Database for PostgreSQL resources that you can optimize for performance. These recommendations are tightly integrated with Azure Advisor to provide you with best practices directly within the Azure portal. <a href=\"https:\/\/azure.microsoft.com\/en-us\/services\/advisor\/\">Azure Advisor<\/a> is a personalized cloud consultant that helps you follow guidelines to optimize your Azure deployments.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">If you\u2019re running your Postgres application on Azure today and you want to see the recommendations we\u2019ve already made to help you optimize your Azure Database for PostgreSQL resources, it\u2019s easy! Just check out the performance recommendations tab in the Azure Advisor.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"types-of-settings-we-make-recommendations-about\">Types of settings we make recommendations about<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">The recommendation feature continuously monitors and analyzes your database servers&#8217; <a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/postgresql\/concepts-monitoring\">telemetry<\/a> to determine if your workload performance can be improved by configuring one or more of the resource settings. Currently, we monitor, analyze, and make recommendations for four different types of settings for your Azure Database for PostgreSQL deployment.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li class=\"wp-block-list-item\"><strong>CPU bottlenecks<\/strong> \u2013 Very high utilization of the CPU over an extended period can cause slow query performance for your workload. Increasing the CPU size is likely to help in optimizing the runtime of the database queries and improve overall performance. We will identify servers with a high CPU utilization that are likely running CPU constrained workloads and recommend scaling your compute.<\/li>\n\n\n\n<li class=\"wp-block-list-item\"><strong>Connection constraints<\/strong> \u2013 Each new connection to Postgres occupies some memory. The database server&#8217;s performance degrades if connections to your server are failing because of an <a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/postgresql\/concepts-limits\">upper limit<\/a> in memory. We will identify servers running with many connection failures and recommend upgrading your server&#8217;s connections limits to provide more memory to your server by scaling up compute or using Memory Optimized SKUs, which have more memory per core.<\/li>\n\n\n\n<li class=\"wp-block-list-item\"><strong>Memory constraints<\/strong> \u2013 A low cache hit ratio can result in slower query performance and increased IOPS. This could be due to a bad query plan or running a memory intensive workload. Fixing the query plan or <a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/postgresql\/concepts-pricing-tiers\">increasing the memory<\/a> of your server will help optimize the execution of the database workload.\u00a0Azure Database for PostgreSQL Recommendation identifies servers affected due to this high buffer pool churn and recommends either fixing the query plan, moving to a higher SKU with more memory, or increasing storage size to get more IOPS.<\/li>\n\n\n\n<li class=\"wp-block-list-item\"><strong>Read-intensive workloads<\/strong> \u2013 The new Azure Database for PostgreSQL recommendation feature leverages workload-based heuristics such as the ratio of reads to writes on the server over the past seven days. Your PostgreSQL resource with a very high read\/writes ratio can result in CPU and\/or memory contentions leading to slow query performance. Adding a <a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/postgresql\/howto-read-replicas-portal\">replica<\/a> will help in scaling out reads to the replica server, preventing CPU and\/or memory constraints on the primary server.\u00a0Azure Database for PostgreSQL Recommendation will identify servers with such high read-intensive workloads and recommend adding a <a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/postgresql\/concepts-read-replicas\">read replica<\/a> to offload some of the read workloads.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"getting-started-with-the-recommendation-feature\">Getting started with the Recommendation feature<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">The only prerequisite for getting started with&nbsp;Azure Database for PostgreSQL Recommendation is that you have an instance of <a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/postgresql\/quickstart-create-server-database-portal\">Azure Database for PostgreSQL<\/a> running with some load.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"access-azure-database-for-postgresql-recommendation-in-the-azure-portal\">Access&nbsp;Azure Database for PostgreSQL Recommendation in the Azure portal<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">You can access the recommendations feature by default with no additional cost. The recommendations provided for your server are accessible either via the Azure Advisors page or the server\u2019s overview page, as shown in Figures 1 and 2 below.<\/p>\n\n\n\n<figure class=\"wp-block-image has-custom-border\"><img decoding=\"async\" src=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2019\/04\/d8cf905e-1263-4973-b8e4-cb0d59c2310c.webp\" alt=\"fig1\" style=\"border-radius:0px\" title=\"fig1\" \/><\/figure>\n\n\n\n<p class=\"has-text-align-center wp-block-paragraph\">Fig 1:&nbsp;Azure Database for PostgreSQL Recommendation on the Azure Advisor\u2019s blade on the portal<\/p>\n\n\n\n<figure class=\"wp-block-image has-custom-border\"><img decoding=\"async\" src=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2019\/04\/5a8d14b6-60a4-4356-96d1-02ca6a65c8fc.webp\" alt=\"Screenshot of Azure Recommendations from the overview blade of your PostgreSQL resource\" style=\"border-radius:0px\" title=\"Screenshot of Azure Recommendations from the overview blade of your PostgreSQL resource\" \/><\/figure>\n\n\n\n<p class=\"has-text-align-center wp-block-paragraph\">Fig 2:&nbsp;Azure Database for PostgreSQL Recommendation from the overview blade of your PostgreSQL resource<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"go-deeper-with-the-recommendation-on-azure-portal\">Go deeper with the recommendation on Azure portal<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">After accessing the type of recommendation, you need to select a specific recommendation. Based on the recommendation type, you can take specific actions to address the performance constraints for the server. You can see the recommendation details as you select the recommendation type (Label 1 in Fig 3). This provides the details you need to optimize your Azure resource. Additionally, you can act on a recommendation by selecting <strong>recommended actions<\/strong> (Label 2 in Figure 3).<\/p>\n\n\n\n<figure class=\"wp-block-image has-custom-border\"><img decoding=\"async\" src=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2019\/04\/6cbbcf6d-f05c-4450-bf37-169b3b38d780.webp\" alt=\"fig3\" style=\"border-radius:0px\" title=\"fig3\" \/><\/figure>\n\n\n\n<p class=\"has-text-align-center wp-block-paragraph\">Fig 3: Gather further recommendation details and take actions<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Azure Advisor provides inline actions, a convenient way to select and implement recommendations without leaving the Azure Advisor portal.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">If you don\u2019t intend to act immediately, you can <strong>postpone<\/strong> a recommendation for a period. You can also <strong>dismiss<\/strong> a recommendation to ensure that it no longer appears. If you do not want to receive recommendations for a specific subscription or resource group, you can configure Azure Advisor via the <a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/advisor\/advisor-overview\">portal<\/a> or by using the <a href=\"https:\/\/docs.microsoft.com\/en-us\/cli\/azure\/advisor?view=azure-cli-latest\">CLI<\/a> to generate recommendations only for those that you specify. For more information about using Azure Advisor, see the article <a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/advisor\/advisor-get-started\">Get started with Azure Advisor<\/a>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">After implementing any recommendation, be sure to evaluate performance to measure the impact of the changes you made.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"feedback-on-the-new-recommendation-feature\">Feedback on the new recommendation feature<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Our early users of the recommendations feature in <a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/postgresql\/quickstart-create-server-database-portal\">Azure Database for PostgreSQL<\/a> have benefitted by the recommendations and the resulting performance improvements. Our goal is to make it easier for you to focus on your application without having to worry about the performance of your database server.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">So, go ahead and check out&nbsp;Azure Database for PostgreSQL Recommendation in the Azure portal. If you identify any problems or want to make a feature suggestion, please reach out to the <a href=\"mailto:AskAzureDBforPostgreSQL@service.microsoft.com\">Ask Azure DB for PostgreSQL alias<\/a>. You can also engage with us on the Azure feedback forums for Azure Database for <a href=\"https:\/\/feedback.azure.com\/forums\/597976-azure-database-for-postgresql\">PostgreSQL<\/a>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">We look forward to hearing from you!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>You no longer have to be a database expert to optimize your database. Make your job easier and start taking advantage of Azure Database for PostgreSQL Recommendation for Microsoft Azure Database for PostgreSQL today.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"ms_queue_id":[],"ep_exclude_from_search":false,"_classifai_error":"","_classifai_text_to_speech_error":"","_alt_title":"","footnotes":"","msx_community_cta_settings":[]},"categories":[1473,1466],"tags":[],"audience":[3057,3055,3056],"content-type":[1511],"product":[1565],"tech-community":[],"topic":[],"coauthors":[547],"class_list":["post-1382","post","type-post","status-publish","format-standard","hentry","category-databases","category-hybrid-multicloud","audience-data-professionals","audience-developers","audience-it-implementors","content-type-best-practices","product-azure-database-for-postgresql","review-flag-1680286581-295","review-flag-1680286581-364","review-flag-1-1680286581-825","review-flag-2-1680286581-601","review-flag-3-1680286581-173","review-flag-and-o-1680286581-349","review-flag-new-1680286579-546"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Optimize performance using Azure Database for PostgreSQL Recommendations | Microsoft Azure Blog<\/title>\n<meta name=\"description\" content=\"You no longer have to be a database expert to optimize your database. Make your job easier and start taking advantage of Azure Database for PostgreSQL Recommendation for Microsoft Azure Database for PostgreSQL today.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/azure.microsoft.com\/en-us\/blog\/optimize-performance-using-azure-database-for-postgresql-recommendations\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Optimize performance using Azure Database for PostgreSQL Recommendations | Microsoft Azure Blog\" \/>\n<meta property=\"og:description\" content=\"You no longer have to be a database expert to optimize your database. Make your job easier and start taking advantage of Azure Database for PostgreSQL Recommendation for Microsoft Azure Database for PostgreSQL today.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/azure.microsoft.com\/en-us\/blog\/optimize-performance-using-azure-database-for-postgresql-recommendations\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft Azure Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/microsoftazure\" \/>\n<meta property=\"article:published_time\" content=\"2019-04-25T00:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-20T19:58:20+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2019\/04\/heart.webp\" \/>\n<meta name=\"author\" content=\"Manish Kumar\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@azure\" \/>\n<meta name=\"twitter:site\" content=\"@azure\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Manish Kumar\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/optimize-performance-using-azure-database-for-postgresql-recommendations\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/optimize-performance-using-azure-database-for-postgresql-recommendations\/\"},\"author\":[{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/author\/manish-kumar\/\",\"@type\":\"Person\",\"@name\":\"Manish Kumar\"}],\"headline\":\"Optimize performance using Azure Database for PostgreSQL Recommendations\",\"datePublished\":\"2019-04-25T00:00:00+00:00\",\"dateModified\":\"2025-06-20T19:58:20+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/optimize-performance-using-azure-database-for-postgresql-recommendations\/\"},\"wordCount\":1055,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/optimize-performance-using-azure-database-for-postgresql-recommendations\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2019\/04\/heart.webp\",\"articleSection\":[\"Databases\",\"Hybrid + multicloud\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/azure.microsoft.com\/en-us\/blog\/optimize-performance-using-azure-database-for-postgresql-recommendations\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/optimize-performance-using-azure-database-for-postgresql-recommendations\/\",\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/optimize-performance-using-azure-database-for-postgresql-recommendations\/\",\"name\":\"Optimize performance using Azure Database for PostgreSQL Recommendations | Microsoft Azure Blog\",\"isPartOf\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/optimize-performance-using-azure-database-for-postgresql-recommendations\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/optimize-performance-using-azure-database-for-postgresql-recommendations\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2019\/04\/heart.webp\",\"datePublished\":\"2019-04-25T00:00:00+00:00\",\"dateModified\":\"2025-06-20T19:58:20+00:00\",\"description\":\"You no longer have to be a database expert to optimize your database. Make your job easier and start taking advantage of Azure Database for PostgreSQL Recommendation for Microsoft Azure Database for PostgreSQL today.\",\"breadcrumb\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/optimize-performance-using-azure-database-for-postgresql-recommendations\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/azure.microsoft.com\/en-us\/blog\/optimize-performance-using-azure-database-for-postgresql-recommendations\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/optimize-performance-using-azure-database-for-postgresql-recommendations\/#primaryimage\",\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2019\/04\/heart.webp\",\"contentUrl\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2019\/04\/heart.webp\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/optimize-performance-using-azure-database-for-postgresql-recommendations\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Blog home\",\"item\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Databases\",\"item\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/category\/databases\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Optimize performance using Azure Database for PostgreSQL Recommendations\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#website\",\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/\",\"name\":\"Microsoft Azure Blog\",\"description\":\"Get the latest Azure news, updates, and announcements from the Azure blog. From product updates to hot topics, hear from the Azure experts.\",\"publisher\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization\",\"name\":\"Microsoft Azure Blog\",\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2024\/06\/microsoft_logo.webp\",\"contentUrl\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2024\/06\/microsoft_logo.webp\",\"width\":512,\"height\":512,\"caption\":\"Microsoft Azure Blog\"},\"image\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/microsoftazure\",\"https:\/\/x.com\/azure\",\"https:\/\/www.instagram.com\/microsoftdeveloper\/\",\"https:\/\/www.linkedin.com\/company\/16188386\",\"https:\/\/www.youtube.com\/user\/windowsazure\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#\/schema\/person\/c702e5edd662b328b49b7e1180cab117\",\"name\":\"shakir\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/9342c7c05bb16548741bc5cd3a3e3b7ee0c8e746844ad2cc582db5beb5514c6f?s=96&d=mm&r=g7664e653ea371ce16eaf75e9fa8952c4\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/9342c7c05bb16548741bc5cd3a3e3b7ee0c8e746844ad2cc582db5beb5514c6f?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/9342c7c05bb16548741bc5cd3a3e3b7ee0c8e746844ad2cc582db5beb5514c6f?s=96&d=mm&r=g\",\"caption\":\"shakir\"},\"sameAs\":[\"https:\/\/azure.microsoft.com\"],\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/author\/shakir\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Optimize performance using Azure Database for PostgreSQL Recommendations | Microsoft Azure Blog","description":"You no longer have to be a database expert to optimize your database. Make your job easier and start taking advantage of Azure Database for PostgreSQL Recommendation for Microsoft Azure Database for PostgreSQL today.","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:\/\/azure.microsoft.com\/en-us\/blog\/optimize-performance-using-azure-database-for-postgresql-recommendations\/","og_locale":"en_US","og_type":"article","og_title":"Optimize performance using Azure Database for PostgreSQL Recommendations | Microsoft Azure Blog","og_description":"You no longer have to be a database expert to optimize your database. Make your job easier and start taking advantage of Azure Database for PostgreSQL Recommendation for Microsoft Azure Database for PostgreSQL today.","og_url":"https:\/\/azure.microsoft.com\/en-us\/blog\/optimize-performance-using-azure-database-for-postgresql-recommendations\/","og_site_name":"Microsoft Azure Blog","article_publisher":"https:\/\/www.facebook.com\/microsoftazure","article_published_time":"2019-04-25T00:00:00+00:00","article_modified_time":"2025-06-20T19:58:20+00:00","og_image":[{"url":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2019\/04\/heart.webp","type":"","width":"","height":""}],"author":"Manish Kumar","twitter_card":"summary_large_image","twitter_creator":"@azure","twitter_site":"@azure","twitter_misc":{"Written by":"Manish Kumar","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/optimize-performance-using-azure-database-for-postgresql-recommendations\/#article","isPartOf":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/optimize-performance-using-azure-database-for-postgresql-recommendations\/"},"author":[{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/author\/manish-kumar\/","@type":"Person","@name":"Manish Kumar"}],"headline":"Optimize performance using Azure Database for PostgreSQL Recommendations","datePublished":"2019-04-25T00:00:00+00:00","dateModified":"2025-06-20T19:58:20+00:00","mainEntityOfPage":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/optimize-performance-using-azure-database-for-postgresql-recommendations\/"},"wordCount":1055,"commentCount":0,"publisher":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization"},"image":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/optimize-performance-using-azure-database-for-postgresql-recommendations\/#primaryimage"},"thumbnailUrl":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2019\/04\/heart.webp","articleSection":["Databases","Hybrid + multicloud"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/azure.microsoft.com\/en-us\/blog\/optimize-performance-using-azure-database-for-postgresql-recommendations\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/optimize-performance-using-azure-database-for-postgresql-recommendations\/","url":"https:\/\/azure.microsoft.com\/en-us\/blog\/optimize-performance-using-azure-database-for-postgresql-recommendations\/","name":"Optimize performance using Azure Database for PostgreSQL Recommendations | Microsoft Azure Blog","isPartOf":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/optimize-performance-using-azure-database-for-postgresql-recommendations\/#primaryimage"},"image":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/optimize-performance-using-azure-database-for-postgresql-recommendations\/#primaryimage"},"thumbnailUrl":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2019\/04\/heart.webp","datePublished":"2019-04-25T00:00:00+00:00","dateModified":"2025-06-20T19:58:20+00:00","description":"You no longer have to be a database expert to optimize your database. Make your job easier and start taking advantage of Azure Database for PostgreSQL Recommendation for Microsoft Azure Database for PostgreSQL today.","breadcrumb":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/optimize-performance-using-azure-database-for-postgresql-recommendations\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/azure.microsoft.com\/en-us\/blog\/optimize-performance-using-azure-database-for-postgresql-recommendations\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/optimize-performance-using-azure-database-for-postgresql-recommendations\/#primaryimage","url":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2019\/04\/heart.webp","contentUrl":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2019\/04\/heart.webp"},{"@type":"BreadcrumbList","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/optimize-performance-using-azure-database-for-postgresql-recommendations\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog home","item":"https:\/\/azure.microsoft.com\/en-us\/blog\/"},{"@type":"ListItem","position":2,"name":"Databases","item":"https:\/\/azure.microsoft.com\/en-us\/blog\/category\/databases\/"},{"@type":"ListItem","position":3,"name":"Optimize performance using Azure Database for PostgreSQL Recommendations"}]},{"@type":"WebSite","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#website","url":"https:\/\/azure.microsoft.com\/en-us\/blog\/","name":"Microsoft Azure Blog","description":"Get the latest Azure news, updates, and announcements from the Azure blog. From product updates to hot topics, hear from the Azure experts.","publisher":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/azure.microsoft.com\/en-us\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization","name":"Microsoft Azure Blog","url":"https:\/\/azure.microsoft.com\/en-us\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2024\/06\/microsoft_logo.webp","contentUrl":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2024\/06\/microsoft_logo.webp","width":512,"height":512,"caption":"Microsoft Azure Blog"},"image":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/microsoftazure","https:\/\/x.com\/azure","https:\/\/www.instagram.com\/microsoftdeveloper\/","https:\/\/www.linkedin.com\/company\/16188386","https:\/\/www.youtube.com\/user\/windowsazure"]},{"@type":"Person","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#\/schema\/person\/c702e5edd662b328b49b7e1180cab117","name":"shakir","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/9342c7c05bb16548741bc5cd3a3e3b7ee0c8e746844ad2cc582db5beb5514c6f?s=96&d=mm&r=g7664e653ea371ce16eaf75e9fa8952c4","url":"https:\/\/secure.gravatar.com\/avatar\/9342c7c05bb16548741bc5cd3a3e3b7ee0c8e746844ad2cc582db5beb5514c6f?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/9342c7c05bb16548741bc5cd3a3e3b7ee0c8e746844ad2cc582db5beb5514c6f?s=96&d=mm&r=g","caption":"shakir"},"sameAs":["https:\/\/azure.microsoft.com"],"url":"https:\/\/azure.microsoft.com\/en-us\/blog\/author\/shakir\/"}]}},"msxcm_display_generated_audio":false,"msxcm_animated_featured_image":null,"distributor_meta":false,"distributor_terms":false,"distributor_media":false,"distributor_original_site_name":"Microsoft Azure Blog","distributor_original_site_url":"https:\/\/azure.microsoft.com\/en-us\/blog","push-errors":false,"_links":{"self":[{"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/posts\/1382","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/comments?post=1382"}],"version-history":[{"count":1,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/posts\/1382\/revisions"}],"predecessor-version":[{"id":42740,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/posts\/1382\/revisions\/42740"}],"wp:attachment":[{"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/media?parent=1382"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/categories?post=1382"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/tags?post=1382"},{"taxonomy":"audience","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/audience?post=1382"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/content-type?post=1382"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/product?post=1382"},{"taxonomy":"tech-community","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/tech-community?post=1382"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/topic?post=1382"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/coauthors?post=1382"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}