{"id":52298,"date":"2026-06-26T10:00:00","date_gmt":"2026-06-26T17:00:00","guid":{"rendered":"https:\/\/azure.microsoft.com\/en-us\/blog\/?p=52298"},"modified":"2026-06-26T12:40:20","modified_gmt":"2026-06-26T19:40:20","slug":"the-performance-dividend-optimizing-postgresql-on-azure-directly-in-visual-studio-code","status":"publish","type":"post","link":"https:\/\/azure.microsoft.com\/en-us\/blog\/the-performance-dividend-optimizing-postgresql-on-azure-directly-in-visual-studio-code\/","title":{"rendered":"The performance dividend: Optimizing PostgreSQL on Azure directly in Visual Studio Code"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Poor database performance is never just a database problem. In enterprise teams, it shows up as missed service-level agreements (SLAs), delayed releases, frustrated development teams, and rising operational risk. The performance problem compounds further in business impact, often resulting in frustrated customers, retention and conversion risk, and lost revenue.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">I have seen this repeatedly while working with enterprises building and running large\u2011scale data platforms, both as a customer and partner, and now with Microsoft. When teams are forced to jump between SQL editors, monitoring dashboards, cloud portals, and documentation just to diagnose a slow query, the real cost is not just technical. It&#8217;s also time, trust, and momentum lost across the business.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"a-more-integrated-way-to-run-postgresql-on-azure\">A more integrated way to run PostgreSQL on Azure<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">This is why I am optimistic about where PostgreSQL on Azure stands today. Microsoft\u2019s investment in open source and PostgreSQL has matured significantly over the last several years. <a href=\"https:\/\/azure.microsoft.com\/en-us\/products\/postgresql\" target=\"_blank\" rel=\"noreferrer noopener\">Azure Database for PostgreSQL<\/a> has evolved into a fully managed, fully open-source enterprise-ready platform, <a href=\"https:\/\/azure.microsoft.com\/en-us\/products\/horizondb\" target=\"_blank\" rel=\"noreferrer noopener\">Azure HorizonDB<\/a> has entered the conversation as the next-gen Postgres on Azure delivering 3x faster performance than self-managed Postgres, and Microsoft is extending that value directly into the tools developers and database administrators (DBAs) already use. The PostgreSQL extension for Visual Studio Code is a clear example of that progress, especially with its new performance\u2011enhancing capabilities.<\/p>\n\n\n\n<div class=\"wp-block-buttons is-style-medium is-content-justification-center is-layout-flex wp-container-core-buttons-is-layout-a89b3969 wp-block-buttons-is-layout-flex\">\n<div class=\"wp-block-button is-style-default\"><a class=\"wp-block-button__link wp-element-button\" href=\"https:\/\/azure.microsoft.com\/en-us\/products\/postgresql\" target=\"_blank\" rel=\"noopener noreferrer\">Try PostgreSQL on Azure<\/a><\/div>\n<\/div>\n\n\n\n<p class=\"wp-block-paragraph\">Most enterprise teams do not lack tooling. They lack integration. Performance work often breaks down because insights live in one place, actions live in another, and context is lost in between. Microsoft\u2019s direction with the PostgreSQL extension for VS Code focuses on closing those gaps by bringing development, diagnostics, and tuning into a single workflow.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The extension is designed to help teams manage PostgreSQL across the full lifecycle, from authoring queries and exploring schemas to monitoring server health and optimizing performance. For organizations standardizing PostgreSQL on Azure, this creates a more coherent operating model that reduces friction between developers, DBAs, and platform teams.<\/p>\n\n\n\n<div class=\"wp-block-buttons is-content-justification-center is-layout-flex wp-container-core-buttons-is-layout-a89b3969 wp-block-buttons-is-layout-flex\">\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link wp-element-button\" href=\"https:\/\/learn.microsoft.com\/en-us\/azure\/postgresql\/development\/vs-code-extension\/postgresql-extension-overview\" target=\"_blank\" rel=\"noopener noreferrer noreferrer noopener\">Learn more about the PostgreSQL extension for VS Code<\/a><\/div>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"seeing-performance-clearly-with-the-server-metrics-dashboard\">Seeing performance clearly with the Server Metrics Dashboard<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">One of the most impactful additions is the <a href=\"https:\/\/github.com\/microsoft\/vscode-pgsql\/discussions\/157\">server metrics dashboard<\/a>. For DBAs and platform engineers, this dashboard brings key performance signals such as CPU, memory, storage, and connections directly into VS Code. Instead of switching contexts to investigate an issue, teams can view metrics where they already work.<\/p>\n\n\n\n<figure data-wp-context=\"{&quot;imageId&quot;:&quot;6a5ab47209529&quot;}\" data-wp-interactive=\"core\/image\" data-wp-key=\"6a5ab47209529\" class=\"wp-block-image size-full wp-lightbox-container\"><img loading=\"lazy\" decoding=\"async\" width=\"1280\" height=\"720\" data-wp-class--hide=\"state.isContentHidden\" data-wp-class--show=\"state.isContentVisible\" data-wp-init=\"callbacks.setButtonStyles\" data-wp-on--click=\"actions.showLightbox\" data-wp-on--load=\"callbacks.setButtonStyles\" data-wp-on-window--resize=\"callbacks.setButtonStyles\" src=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2026\/06\/metrics-dashboard-1.gif\" alt=\"Scrolling through high C P U no index dashboard.\" class=\"wp-image-52357\" \/><button\n\t\t\tclass=\"lightbox-trigger\"\n\t\t\ttype=\"button\"\n\t\t\taria-haspopup=\"dialog\"\n\t\t\taria-label=\"Enlarge\"\n\t\t\tdata-wp-init=\"callbacks.initTriggerButton\"\n\t\t\tdata-wp-on--click=\"actions.showLightbox\"\n\t\t\tdata-wp-style--right=\"state.imageButtonRight\"\n\t\t\tdata-wp-style--top=\"state.imageButtonTop\"\n\t\t>\n\t\t\t<svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"12\" height=\"12\" fill=\"none\" viewBox=\"0 0 12 12\">\n\t\t\t\t<path fill=\"#fff\" d=\"M2 0a2 2 0 0 0-2 2v2h1.5V2a.5.5 0 0 1 .5-.5h2V0H2Zm2 10.5H2a.5.5 0 0 1-.5-.5V8H0v2a2 2 0 0 0 2 2h2v-1.5ZM8 12v-1.5h2a.5.5 0 0 0 .5-.5V8H12v2a2 2 0 0 1-2 2H8Zm2-12a2 2 0 0 1 2 2v2h-1.5V2a.5.5 0 0 0-.5-.5H8V0h2Z\" \/>\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Because the dashboard is integrated with Azure, it provides Azure\u2011specific telemetry and historical insights that help teams understand trends, not just snapshots. When performance issues arise, the time from detection to investigation is significantly reduced.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"from-insight-to-action-with-azure-advisor-in-vs-code\">From insight to action with Azure Advisor in VS Code<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Observability only matters if it leads to action. The PostgreSQL extension surfaces <a href=\"https:\/\/learn.microsoft.com\/en-us\/azure\/postgresql\/configure-maintain\/concepts-azure-advisor-recommendations\" target=\"_blank\" rel=\"noopener noreferrer\">Azure Advisor<\/a> recommendations directly in the editor, connecting performance insights with concrete guidance. These recommendations can include suggestions around configuration, indexing, and resource optimization based on Azure telemetry.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">For enterprise teams, this shortens the feedback loop. Instead of manually correlating metrics with best practices, teams receive contextual recommendations aligned to their actual workloads. This improves operational confidence and helps standardize tuning practices across environments.<\/p>\n\n\n\n<div class=\"wp-block-buttons is-content-justification-center is-layout-flex wp-container-core-buttons-is-layout-a89b3969 wp-block-buttons-is-layout-flex\">\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link wp-element-button\" href=\"https:\/\/learn.microsoft.com\/en-us\/azure\/postgresql\/configure-maintain\/concepts-azure-advisor-recommendations\" target=\"_blank\" rel=\"noopener noreferrer noreferrer noopener\">Optimize your resources with Azure Advisor<\/a><\/div>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"faster-diagnosis-with-query-plan-visualization-and-ai-assistance\">Faster diagnosis with Query Plan visualization and AI assistance<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Performance tuning often comes down to understanding query behavior. Recent improvements to the extension enhance query plan visualization, making execution plans easier to interpret during troubleshooting and optimization.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Beyond visualization, Microsoft is embedding AI\u2011assisted query analysis and optimization directly into the workflow. Developers and DBAs can analyze query plans, understand potential bottlenecks, and explore optimization options without leaving VS Code. This does not replace deep PostgreSQL expertise, but it helps teams move faster and make better decisions earlier in the development cycle.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">These capabilities are especially valuable for enterprise environments where not every developer is a PostgreSQL specialist, yet performance expectations remain high.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"better-authoring-experiences-reduce-performance-issues-upstream\">Better authoring experiences reduce performance issues upstream<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Performance work does not start in production. It starts when schemas are designed and queries are written. The PostgreSQL extension improves this experience with schema\u2011aware IntelliSense, search_path\u2011aware query authoring, and reliable object explorer behavior for large and complex databases.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Developers can write, run, and refine SQL with better context, while DBAs benefit from more consistent and predictable interactions with large schema estates. Improvements to object explorer reliability also matter at enterprise scale, where long\u2011running sessions and frequent refreshes are common.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\n  Combined with <a href=\"https:\/\/learn.microsoft.com\/en-us\/azure\/postgresql\/security\/security-entra-configure\">Microsoft Entra ID<\/a> authentication and integrated Azure resource discovery, the extension provides a secure and governed way to work with PostgreSQL across development and production environments.\n<\/p>\n\n\n\n<div class=\"wp-block-buttons is-content-justification-center is-layout-flex wp-container-core-buttons-is-layout-a89b3969 wp-block-buttons-is-layout-flex\">\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link wp-element-button\" href=\"https:\/\/learn.microsoft.com\/en-us\/azure\/postgresql\/development\/vs-code-extension\/quickstart-connect-query?tabs=vscode\" target=\"_blank\" rel=\"noopener noreferrer noreferrer noopener\">Try PostgreSQL extension for VS Code<\/a><\/div>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"from-tuning-to-performance-payout\">From tuning to performance payout<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Taken together, these capabilities change the day\u2011to\u2011day experience of <a href=\"https:\/\/azure.microsoft.com\/en-us\/products\/postgresql\" target=\"_blank\" rel=\"noreferrer noopener\">running PostgreSQL on Azure<\/a>. Azure Database for PostgreSQL already delivers the managed fundamentals enterprises expect, including high availability, security, and best\u2011practice guidance. The PostgreSQL extension for VS Code extends that value into execution by making performance management part of the same workflow as development.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">This integration is a practical differentiator. It reflects an understanding of how enterprise teams actually work and where time is lost today. Instead of adding more tools, Azure is tightening the loop between insight and action.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"a-look-ahead-ai-native-postgresql-with-azure-horizondb\">A look ahead: AI\u2011native PostgreSQL with Azure HorizonDB<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">As enterprises look toward AI\u2011native architectures, Microsoft is also introducing <a href=\"https:\/\/azure.microsoft.com\/en-us\/products\/horizondb\" target=\"_blank\" rel=\"noreferrer noopener\">Azure HorizonDB in public preview<\/a>. Azure HorizonDB is designed for cloud\u2011native, AI\u2011ready PostgreSQL\u2011compatible workloads that require advanced scalability and integrated AI capabilities.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">For most production workloads today, <a href=\"https:\/\/azure.microsoft.com\/en-us\/products\/postgresql\" target=\"_blank\" rel=\"noreferrer noopener\">Azure Database for PostgreSQL<\/a> remains the recommended choice. <a href=\"https:\/\/azure.microsoft.com\/en-us\/products\/horizondb\" target=\"_blank\" rel=\"noreferrer noopener\">Azure HorizonDB<\/a> represents an adjacent, forward\u2011looking option for teams exploring what comes next for their AI\u2011powered applications.<\/p>\n\n\n\n<div class=\"wp-block-buttons is-content-justification-center is-layout-flex wp-container-core-buttons-is-layout-a89b3969 wp-block-buttons-is-layout-flex\">\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link wp-element-button\" href=\"https:\/\/youtu.be\/dl98C_Pgne8?si=AkCFSut74YwdDWVh\" target=\"_blank\" rel=\"noopener noreferrer\">Watch video: Azure HorizonDB + VS Code: Your AI App Development Workspace<\/a><\/div>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"turning-performance-into-a-competitive-advantage\">Turning performance into a competitive advantage<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">The real advantage of these new capabilities is the way they come together to reduce friction, improve clarity, and help teams act faster. For enterprises managing PostgreSQL at scale, that translates directly into better reliability, faster delivery, and lower operational risk.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">If you are running PostgreSQL on Azure today, now is a good time to see what this looks like in practice. Try the PostgreSQL extension for VS Code and connect it to your Postgres databases on Azure to diagnose issues faster, optimize performance with greater confidence, and keep critical workloads running the way your business and your customers expect.<\/p>\n\n\n\n<div class=\"is-style-inline wp-block-bloginabox-theme-promotional\">\n\t\n<div class=\"promotional promotional--has-media promotional--media-right\">\n\t<div class=\"promotional__wrapper\">\n\t\t<div class=\"promotional__content-wrapper\">\n\t\t\t<div class=\"promotional__content\">\n\t\t\t\t\n\n<h2 class=\"wp-block-heading\" id=\"try-the-postgresql-extension-for-vs-code\">Try the PostgreSQL extension for VS Code<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Diagnose issues faster and optimize performance with confidence <\/p>\n\n\n\n<div class=\"wp-block-buttons is-layout-flex wp-block-buttons-is-layout-flex\">\n<div class=\"wp-block-button\"><a data-bi-an=\"Global CTA\" data-bi-ct=\"cta link\" data-bi-id=\"cta-block\" class=\"wp-block-button__link wp-element-button\" href=\"https:\/\/learn.microsoft.com\/en-us\/azure\/postgresql\/development\/vs-code-extension\/quickstart-connect-query?tabs=vscode\" target=\"_blank\" rel=\"noopener noreferrer noreferrer noopener\">Get started<\/a><\/div>\n<\/div>\n\n\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<div class=\"promotional__media-wrapper\">\n\t\t\t\t<div class=\"promotional__media\">\n\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"1920\" height=\"1080\" src=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2026\/06\/Azure-migration-free-services-2.jpg\" class=\"attachment-full size-full\" alt=\"Abstract 3D cubes and spheres floating on a blue grid background with a curved turquoise line.\" loading=\"lazy\" srcset=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2026\/06\/Azure-migration-free-services-2.jpg 1920w, https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2026\/06\/Azure-migration-free-services-2-300x169.jpg 300w, https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2026\/06\/Azure-migration-free-services-2-1024x576.jpg 1024w, https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2026\/06\/Azure-migration-free-services-2-768x432.jpg 768w, https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2026\/06\/Azure-migration-free-services-2-1536x864.jpg 1536w, https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2026\/06\/Azure-migration-free-services-2-809x455.jpg 809w\" sizes=\"auto, (max-width: 1920px) 100vw, 1920px\" \/>\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t\t<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Poor database performance is never just a database problem. In enterprise teams, it shows up as missed SLAs, delayed releases, frustrated development teams, and rising operational risk. The performance problem compounds further in business impact, often resulting in frustrated customers, retention and conversion risk, and lost revenue.<\/p>\n","protected":false},"author":58,"featured_media":52299,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"ep_exclude_from_search":false,"_classifai_error":"","_classifai_text_to_speech_error":"","_alt_title":"","ms-ems-related-posts":[],"footnotes":"","azure_community_cta_settings":[]},"categories":[1473,1466],"tags":[3376,3391],"audience":[3055,3053],"content-type":[1465],"product":[1565,3351],"tech-community":[],"coauthors":[3344],"class_list":["post-52298","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-databases","category-hybrid-multicloud","tag-postgresql","tag-visual-studio","audience-developers","audience-it-decision-makers","content-type-announcements","product-azure-database-for-postgresql","product-azure-horizon-db","review-flag-1680286581-364","review-flag-microsofts","review-flag-never-1680286580-606","review-flag-new-1680286579-546","review-flag-partn-1680286579-901","review-flag-publi-1680286584-566"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Optimizing PostgreSQL on Azure directly in Visual Studio Code<\/title>\n<meta name=\"description\" content=\"Learn how to optimize PostgreSQL on Azure directly in VS Code using AI, real-time insights, and Azure tools to improve database performance and accelerate delivery.\" \/>\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\/the-performance-dividend-optimizing-postgresql-on-azure-directly-in-visual-studio-code\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Optimizing PostgreSQL on Azure directly in Visual Studio Code\" \/>\n<meta property=\"og:description\" content=\"Learn how to optimize PostgreSQL on Azure directly in VS Code using AI, real-time insights, and Azure tools to improve database performance and accelerate delivery.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/azure.microsoft.com\/en-us\/blog\/the-performance-dividend-optimizing-postgresql-on-azure-directly-in-visual-studio-code\/\" \/>\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=\"2026-06-26T17:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-06-26T19:40:20+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2026\/06\/PostgreSQL-database-admin-3.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1920\" \/>\n\t<meta property=\"og:image:height\" content=\"1080\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Jesse Sullivan\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:image\" content=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2026\/06\/PostgreSQL-database-admin-3.jpg\" \/>\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=\"Jesse Sullivan\" \/>\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\\\/the-performance-dividend-optimizing-postgresql-on-azure-directly-in-visual-studio-code\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/azure.microsoft.com\\\/en-us\\\/blog\\\/the-performance-dividend-optimizing-postgresql-on-azure-directly-in-visual-studio-code\\\/\"},\"author\":[{\"@id\":\"https:\\\/\\\/azure.microsoft.com\\\/en-us\\\/blog\\\/author\\\/jesse-sullivan\\\/\",\"@type\":\"Person\",\"@name\":\"Jesse Sullivan\"}],\"headline\":\"The performance dividend: Optimizing PostgreSQL on Azure directly in Visual Studio Code\",\"datePublished\":\"2026-06-26T17:00:00+00:00\",\"dateModified\":\"2026-06-26T19:40:20+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/azure.microsoft.com\\\/en-us\\\/blog\\\/the-performance-dividend-optimizing-postgresql-on-azure-directly-in-visual-studio-code\\\/\"},\"wordCount\":1083,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/azure.microsoft.com\\\/en-us\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/azure.microsoft.com\\\/en-us\\\/blog\\\/the-performance-dividend-optimizing-postgresql-on-azure-directly-in-visual-studio-code\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/azure.microsoft.com\\\/en-us\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/06\\\/PostgreSQL-database-admin-3.jpg\",\"keywords\":[\"PostgreSQL\",\"Visual Studio\"],\"articleSection\":[\"Databases\",\"Hybrid + multicloud\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/azure.microsoft.com\\\/en-us\\\/blog\\\/the-performance-dividend-optimizing-postgresql-on-azure-directly-in-visual-studio-code\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/azure.microsoft.com\\\/en-us\\\/blog\\\/the-performance-dividend-optimizing-postgresql-on-azure-directly-in-visual-studio-code\\\/\",\"url\":\"https:\\\/\\\/azure.microsoft.com\\\/en-us\\\/blog\\\/the-performance-dividend-optimizing-postgresql-on-azure-directly-in-visual-studio-code\\\/\",\"name\":\"Optimizing PostgreSQL on Azure directly in Visual Studio Code\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/azure.microsoft.com\\\/en-us\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/azure.microsoft.com\\\/en-us\\\/blog\\\/the-performance-dividend-optimizing-postgresql-on-azure-directly-in-visual-studio-code\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/azure.microsoft.com\\\/en-us\\\/blog\\\/the-performance-dividend-optimizing-postgresql-on-azure-directly-in-visual-studio-code\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/azure.microsoft.com\\\/en-us\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/06\\\/PostgreSQL-database-admin-3.jpg\",\"datePublished\":\"2026-06-26T17:00:00+00:00\",\"dateModified\":\"2026-06-26T19:40:20+00:00\",\"description\":\"Learn how to optimize PostgreSQL on Azure directly in VS Code using AI, real-time insights, and Azure tools to improve database performance and accelerate delivery.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/azure.microsoft.com\\\/en-us\\\/blog\\\/the-performance-dividend-optimizing-postgresql-on-azure-directly-in-visual-studio-code\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/azure.microsoft.com\\\/en-us\\\/blog\\\/the-performance-dividend-optimizing-postgresql-on-azure-directly-in-visual-studio-code\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/azure.microsoft.com\\\/en-us\\\/blog\\\/the-performance-dividend-optimizing-postgresql-on-azure-directly-in-visual-studio-code\\\/#primaryimage\",\"url\":\"https:\\\/\\\/azure.microsoft.com\\\/en-us\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/06\\\/PostgreSQL-database-admin-3.jpg\",\"contentUrl\":\"https:\\\/\\\/azure.microsoft.com\\\/en-us\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/06\\\/PostgreSQL-database-admin-3.jpg\",\"width\":1920,\"height\":1080,\"caption\":\"people sitting in front of computers\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/azure.microsoft.com\\\/en-us\\\/blog\\\/the-performance-dividend-optimizing-postgresql-on-azure-directly-in-visual-studio-code\\\/#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\":\"The performance dividend: Optimizing PostgreSQL on Azure directly in Visual Studio Code\"}]},{\"@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\\\/c505c4707a8b0733197cd32e481f1fae\",\"name\":\"Estela Virko\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/e0c80aef45905808b531834966f343f124eab0a088eaf8c5091c92e213cf58e5?s=96&d=mm&r=ge79ba33f176c2122a103010d5e208f8b\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/e0c80aef45905808b531834966f343f124eab0a088eaf8c5091c92e213cf58e5?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/e0c80aef45905808b531834966f343f124eab0a088eaf8c5091c92e213cf58e5?s=96&d=mm&r=g\",\"caption\":\"Estela Virko\"},\"url\":\"https:\\\/\\\/azure.microsoft.com\\\/en-us\\\/blog\\\/author\\\/estelavirko\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Optimizing PostgreSQL on Azure directly in Visual Studio Code","description":"Learn how to optimize PostgreSQL on Azure directly in VS Code using AI, real-time insights, and Azure tools to improve database performance and accelerate delivery.","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\/the-performance-dividend-optimizing-postgresql-on-azure-directly-in-visual-studio-code\/","og_locale":"en_US","og_type":"article","og_title":"Optimizing PostgreSQL on Azure directly in Visual Studio Code","og_description":"Learn how to optimize PostgreSQL on Azure directly in VS Code using AI, real-time insights, and Azure tools to improve database performance and accelerate delivery.","og_url":"https:\/\/azure.microsoft.com\/en-us\/blog\/the-performance-dividend-optimizing-postgresql-on-azure-directly-in-visual-studio-code\/","og_site_name":"Microsoft Azure Blog","article_publisher":"https:\/\/www.facebook.com\/microsoftazure","article_published_time":"2026-06-26T17:00:00+00:00","article_modified_time":"2026-06-26T19:40:20+00:00","og_image":[{"width":1920,"height":1080,"url":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2026\/06\/PostgreSQL-database-admin-3.jpg","type":"image\/jpeg"}],"author":"Jesse Sullivan","twitter_card":"summary_large_image","twitter_image":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2026\/06\/PostgreSQL-database-admin-3.jpg","twitter_creator":"@azure","twitter_site":"@azure","twitter_misc":{"Written by":"Jesse Sullivan","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/the-performance-dividend-optimizing-postgresql-on-azure-directly-in-visual-studio-code\/#article","isPartOf":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/the-performance-dividend-optimizing-postgresql-on-azure-directly-in-visual-studio-code\/"},"author":[{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/author\/jesse-sullivan\/","@type":"Person","@name":"Jesse Sullivan"}],"headline":"The performance dividend: Optimizing PostgreSQL on Azure directly in Visual Studio Code","datePublished":"2026-06-26T17:00:00+00:00","dateModified":"2026-06-26T19:40:20+00:00","mainEntityOfPage":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/the-performance-dividend-optimizing-postgresql-on-azure-directly-in-visual-studio-code\/"},"wordCount":1083,"commentCount":0,"publisher":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization"},"image":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/the-performance-dividend-optimizing-postgresql-on-azure-directly-in-visual-studio-code\/#primaryimage"},"thumbnailUrl":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2026\/06\/PostgreSQL-database-admin-3.jpg","keywords":["PostgreSQL","Visual Studio"],"articleSection":["Databases","Hybrid + multicloud"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/azure.microsoft.com\/en-us\/blog\/the-performance-dividend-optimizing-postgresql-on-azure-directly-in-visual-studio-code\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/the-performance-dividend-optimizing-postgresql-on-azure-directly-in-visual-studio-code\/","url":"https:\/\/azure.microsoft.com\/en-us\/blog\/the-performance-dividend-optimizing-postgresql-on-azure-directly-in-visual-studio-code\/","name":"Optimizing PostgreSQL on Azure directly in Visual Studio Code","isPartOf":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/the-performance-dividend-optimizing-postgresql-on-azure-directly-in-visual-studio-code\/#primaryimage"},"image":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/the-performance-dividend-optimizing-postgresql-on-azure-directly-in-visual-studio-code\/#primaryimage"},"thumbnailUrl":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2026\/06\/PostgreSQL-database-admin-3.jpg","datePublished":"2026-06-26T17:00:00+00:00","dateModified":"2026-06-26T19:40:20+00:00","description":"Learn how to optimize PostgreSQL on Azure directly in VS Code using AI, real-time insights, and Azure tools to improve database performance and accelerate delivery.","breadcrumb":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/the-performance-dividend-optimizing-postgresql-on-azure-directly-in-visual-studio-code\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/azure.microsoft.com\/en-us\/blog\/the-performance-dividend-optimizing-postgresql-on-azure-directly-in-visual-studio-code\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/the-performance-dividend-optimizing-postgresql-on-azure-directly-in-visual-studio-code\/#primaryimage","url":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2026\/06\/PostgreSQL-database-admin-3.jpg","contentUrl":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2026\/06\/PostgreSQL-database-admin-3.jpg","width":1920,"height":1080,"caption":"people sitting in front of computers"},{"@type":"BreadcrumbList","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/the-performance-dividend-optimizing-postgresql-on-azure-directly-in-visual-studio-code\/#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":"The performance dividend: Optimizing PostgreSQL on Azure directly in Visual Studio Code"}]},{"@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\/c505c4707a8b0733197cd32e481f1fae","name":"Estela Virko","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/e0c80aef45905808b531834966f343f124eab0a088eaf8c5091c92e213cf58e5?s=96&d=mm&r=ge79ba33f176c2122a103010d5e208f8b","url":"https:\/\/secure.gravatar.com\/avatar\/e0c80aef45905808b531834966f343f124eab0a088eaf8c5091c92e213cf58e5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/e0c80aef45905808b531834966f343f124eab0a088eaf8c5091c92e213cf58e5?s=96&d=mm&r=g","caption":"Estela Virko"},"url":"https:\/\/azure.microsoft.com\/en-us\/blog\/author\/estelavirko\/"}]}},"bloginabox_animated_featured_image":null,"bloginabox_display_generated_audio":true,"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\/52298","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\/58"}],"replies":[{"embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/comments?post=52298"}],"version-history":[{"count":20,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/posts\/52298\/revisions"}],"predecessor-version":[{"id":52393,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/posts\/52298\/revisions\/52393"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/media\/52299"}],"wp:attachment":[{"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/media?parent=52298"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/categories?post=52298"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/tags?post=52298"},{"taxonomy":"audience","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/audience?post=52298"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/content-type?post=52298"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/product?post=52298"},{"taxonomy":"tech-community","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/tech-community?post=52298"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/coauthors?post=52298"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}