The Curious Engineer

All blogs / Databases

Microsoft Blog for PostgreSQL

techcommunity.microsoft.com/category/azuredatabases/blog/adforpostgresql

DatabasesPerformance / optimizationDistributed systems / cloudMicrosoft blogsMicrosoft Tech Community

’19’20’21’22’23’24’25’26
Posts
419 from 14 Jun 2019 to 28 Oct 2026
Posting
weekly (99 in the last year)
Kind
company blog

2026 86

  1. Why Microsoft contributes to Postgres: What I tell people
  2. Wolters Kluwer scales tax and accounting software with PostgreSQL on Azure
  3. Using PostgreSQL to reflect on its own history and code: introducing pghacker-mcp.dev
  4. The Invisible Storage Leak: How Replication Slots Can Fill Azure PostgreSQL Flexible Server Storage
  5. September 2026 Recap: Azure Database for PostgreSQL
  6. From Alert to Online Repack: Playbook for PostgreSQL Table Bloat on Azure Database for PostgreSQL
  7. Postgres Trip Report from Postgres Summit US 2026
  8. What sustained PostgreSQL performance really requires: Lessons from an independent benchmark
  9. Rethinking Memory Management for Azure HorizonDB on Disaggregated Storage
  10. AI features in Azure databases
  11. Postgres MCP Server: Connect AI coding agents to PostgreSQL
  12. A Single View of Your PostgreSQL Estate: Database Hub in Public Preview
  13. PostGIS and AI Retrieval in Azure HorizonDB
  14. The need for a maintainer mindset in the age of LLMs
  15. Database Change Management - Azure Database for PostgreSQL, GitHub Actions and Liquibase OSS
  16. Recovering TPS After a Cross-Database Migration
  17. Postgres Skills: Give Your AI Agent PostgreSQL Expertise
  18. Preview PG18 for Elastic Clusters of Azure Postgres
  19. August 2026 Recap: Azure Database for PostgreSQL
  20. Smarter Storage for Azure HorizonDB
  21. Filtered PostgreSQL Logical Replication for Microsoft Fabric Mirroring
  22. Connecting Azure PostgreSQL to Oracle Autonomous with ORACLE_FDW
  23. Better Price Performance: Azure Postgres V3 & V5 Compute Compared
  24. Transaction ID (XID) Wraparound Protection in Azure Database for PostgreSQL Flexible Server
  25. Understanding and Reclaiming Storage After DELETE in Azure Database for PostgreSQL
  26. Why PostgreSQL Still Inspires Builders
  27. July 2026 Recap: Azure Database for PostgreSQL
  28. Oracle to PostgreSQL in VS Code: Assessment, Conversion, and Validation
  29. Get started faster in the PostgreSQL extension for VS Code
  30. AI-assisted Oracle-to-PostgreSQL schema conversion in Visual Studio Code
  31. Faster, Safer Version Upgrades for Databases with Large Objects
  32. Top 10 Performance Optimization Techniques for Azure Database for PostgreSQL Flexible Server
  33. AI-Powered Retrieval in PostgreSQL with Azure HorizonDB
  34. TLS Certificate Pinning and Best Practices in Azure Database for PostgreSQL
  35. Monitoring and using pg_repack in Azure Database for PostgreSQL flexible server
  36. Microsoft Defender CSPM Assessments for Azure Database for PostgreSQL Flexible Server - GA
  37. June 2026 Recap: Azure Database for PostgreSQL
  38. PostgreSQL on Azure: Two services, one future-proofed ecosystem
  39. From RAG to agents: Build AI pipelines inside Azure HorizonDB
  40. Log Insights in Minutes: A Simpler pgBadger Workflow
  41. Take control of your PostgreSQL maintenance
  42. Build a Knowledge Graph in Azure HorizonDB with AI Functions and Apache AGE
  43. Last Call: Join Live the PostgreSQL Community at POSETTE: An Event for Postgres 2026 (T‑1 week)
  44. What's new with Postgres at Microsoft, 2026 edition
  45. Introducing Durable Functions in PostgreSQL
  46. Make upgrades predictable with Pre-Upgrade Validation Checks
  47. Announcing new security, maintenance and analytics features for PostgreSQL at Microsoft Build 2026
  48. Azure HorizonDB: Enterprise-Ready Postgres, Engineered for the AI Era
  49. Your PostgreSQL workflow just found its new home in Cursor
  50. PostgreSQL Meets AI at POSETTE: An Event for Postgres 2026 (T-3 weeks)
  51. Introducing PostgreSQL Hub for Azure Developers
  52. Demystifying LWLock: MultiXact SLRU Wait Events in Azure Database for PostgreSQL
  53. SELECT * FROM build2026_sessions WHERE postgres = true;
  54. Real-World Success Stories with PostgreSQL on Azure
  55. Native Database/Query Monitoring with Azure Database for PostgreSQL
  56. Ultimate Guide to POSETTE: An Event for Postgres, 2026 edition
  57. April 2026 Recap: Azure Database for PostgreSQL
  58. End-to-end workload observability with Query Store for primary and replicas
  59. You don't want to miss POSETTE: An Event for Postgres 2026 (T-6 weeks)
  60. When PostgreSQL v17 Chooses the Wrong Plan: A Deep Dive into CTEs with Data Skew
  61. PostgreSQL as your Graph Database in the AI era
  62. Potential Consequences of Using Postgres as a Job Queue
  63. Connection Scaling in Elastic Clusters
  64. General Availability Refresh: Mirroring Azure Database for PostgreSQL in Microsoft Fabric
  65. March 2026 Recap: Azure Database for PostgreSQL
  66. Combining pgvector and Apache AGE - knowledge graph & semantic intelligence in a single engine
  67. Cascading Read Replicas Now Generally Available!
  68. Premium SSD v2 Is Now Generally Available for Azure Database for PostgreSQL
  69. Handling Unique Constraint Conflicts in Logical Replication
  70. No code left behind: How AI streamlines Oracle-to-PostgreSQL migration
  71. PostgreSQL Buffer Cache Analysis
  72. Bidirectional Replication with pglogical on Azure Database for PostgreSQL - a VNET guide
  73. PostgreSQL Query Rewriting and Subqueries
  74. GraphRAG and PostgreSQL integration in docker with Cypher query and AI agents (Version 2*)
  75. February 2026 Recap: Azure Database for PostgreSQL
  76. Understanding Hash Join Memory Usage and OOM Risks in PostgreSQL
  77. Dashboards with Grafana - Now in Azure Portal for PostgreSQL
  78. Nasdaq builds thoughtfully designed AI for board governance with PostgreSQL on Azure
  79. Microsoft at PGConf India 2026
  80. Mastering gin_pending_list_limit: How This parameter shapes GIN index insert performance
  81. Distribute PostgreSQL 18 with Citus 14
  82. AlphaLife Sciences powers regulatory-compliant AI workflows with PostgreSQL on Azure
  83. January 2026 Recap: Azure Database for PostgreSQL
  84. Supporting ChatGPT on PostgreSQL in Azure
  85. Postgres speakers - POSETTE 2026 CFP is closing soon!
  86. General Availability of Mirroring Azure Database for PostgreSQL in Microsoft Fabric Is Here!

2025 74

  1. Performance Tuning for CDC: Managing Replication Lag in Azure Database for PostgreSQL with Debezium
  2. November 2025 Recap: PostgreSQL on Azure
  3. From Oracle to Azure: How Quadrant Technologies accelerates migrations
  4. SubgenAI makes AI practical, scalable, and sustainable with Azure Database for PostgreSQL
  5. PostgreSQL: Migrating Large Objects (LOBs) with Parallelism and PIPES
  6. PostgreSQL 18 Now GA on Azure Postgres Flexible Server
  7. Build Smarter with Azure HorizonDB
  8. PostgreSQL for the enterprise: scale, secure, simplify
  9. Announcing Azure HorizonDB
  10. October 2025 Recap: Azure Database for PostgreSQL
  11. Exciting things on the horizon for PostgreSQL fans @ Ignite 2025
  12. Upgrade Azure Database for PostgreSQL with Minimal Downtime Using Logical Replication
  13. Postgres Trip Summary from PGConf EU 2025 (with lots of photos)
  14. Mastering Postgres_FDW: Setup, optimize performance and avoid Common Pitfalls
  15. PostgreSQL 18 Vacuuming Improvements Explained
  16. General Availability of Online Migration to Azure Database for PostgreSQL Flexible server
  17. Postgres Trip Report from PGConf NYC 2025 (with lots of photos)
  18. September 2025 Recap: Azure Database for PostgreSQL
  19. PgBouncer Best Practices in Azure Database for PostgreSQL – Part 1
  20. PostgreSQL and the Power of Community
  21. PostgreSQL Discovery and Assessment in Azure Migrate – Public Preview
  22. Architecting Secure PostgreSQL on Azure: Insights from Mercedes-Benz
  23. PostgreSQL 18 Preview on Azure Postgres Flexible Server
  24. Announcing Azure Confidential Computing for Azure Database for PostgreSQL (GA)
  25. Build Enterprise-Ready AI Agents with the New Azure Postgres LangChain + LangGraph Connector
  26. Real AI development and real wins with the new VS Code extension for PostgreSQL
  27. August 2025 Recap: Azure Database for PostgreSQL
  28. The definitive guide to Bi-directional Replication in Azure Database for PostgreSQL
  29. Prevent Accidental Deletion of an Instance in Azure Postgres
  30. New Azure PostgreSQL Solution Accelerator: AgenticShop
  31. Azure PostgreSQL Extended Support: Stay Secure at Every Stage of Your Upgrade
  32. July 2025 Recap: Azure Database for PostgreSQL
  33. Fueling the Agentic Web Revolution with NLWeb and PostgreSQL
  34. Validate Updates Early by Staggering Maintenance in Azure PostgreSQL
  35. Bits of wisdom from a year of Talking Postgres
  36. Mirroring Azure Database for PostgreSQL flexible server behind VNET and Private Endpoint
  37. June 2025 Recap: Azure Database for PostgreSQL
  38. Premium SSD v2 Brings Enhanced HA to Azure Database for PostgreSQL flexible server
  39. Build AI-Ready Apps and Agents with PostgreSQL on Azure
  40. New ESG study validates how fully managed PostgreSQL on Azure delivers economic wins
  41. PostgreSQL 17 General Availability with In-Place Upgrade Support
  42. Scaling PostgreSQL at OpenAI: Lessons in Reliability, Efficiency, and Innovation
  43. Ultimate Guide to POSETTE: An Event for Postgres, 2025 edition
  44. Long-term Backups in Azure Database for PostgreSQL – Flexible Server Now Generally Available
  45. Automatic CMK Key Version Updates for PostgreSQL Flex – GA
  46. Bringing Generative AI to Your Data: Semantic Operators in Azure Database for PostgreSQL
  47. General Availability of Graph Database Support in Azure Database for PostgreSQL
  48. Azure MCP Server now includes support for Azure Database for PostgreSQL
  49. Announcing a new IDE for PostgreSQL in VS Code from Microsoft
  50. Upgrade performance, availability and security with new features in Azure Database for PostgreSQL
  51. New Generative AI Features in Azure Database for PostgreSQL
  52. DiskANN on Azure Database for PostgreSQL – Now Generally Available
  53. PostgreSQL 17 In-Place Upgrade – Now in Public Preview
  54. Innovating with PostgreSQL @Build
  55. April 2025 Recap: Azure Database for PostgreSQL Flexible Server
  56. Hacking the migration service in Azure Database for PostgreSQL
  57. Managing bloat in PostgreSQL using pgstattuple on Azure Database for PostgreSQL flexible server
  58. What's new with Postgres at Microsoft, 2025 edition
  59. UBS unlocks advanced AI techniques with PostgreSQL on Azure
  60. New: Versionless CMK in Azure Database for PostgreSQL
  61. On-Demand Backups in Azure Database for PostgreSQL – Flexible Server Now Generally Available
  62. Introducing Model Context Protocol (MCP) Server for Azure Database for PostgreSQL (Preview)
  63. March 2025 Recap: Azure Database for PostgreSQL Flexible Server
  64. PostgreSQL Query Performance: A Guide to Function Optimization
  65. Announcing Mirroring for Azure Database for PostgreSQL in Microsoft Fabric for Public Preview
  66. Build AI Agents with Azure Database for PostgreSQL and Azure AI Agent Service
  67. Microsoft PostgreSQL OSS engine team: reflecting on 2024
  68. Turbocharge Your Azure PostgreSQL Database: Mastering the Art of Fast Inserts
  69. Boost Your Postgres Server on Azure with Enhanced Azure Advisor Performance Recommendations!
  70. pg_signal_autovacuum_worker Role for Managing Autovacuum in Azure Database for PostgreSQL
  71. Postgres horizontal scaling with elastic clusters expands to more regions
  72. Scalable Vector Search with DiskANN - Available to all Azure Database for PostgreSQL
  73. January 2025 Recap: Azure Database for PostgreSQL Flexible Server
  74. CFP talk proposal ideas for POSETTE: An Event for Postgres 2025

2024 56

  1. On-Demand Backups in Azure Database for PostgreSQL Flexible Server - Public Preview
  2. Introducing the GraphRAG Solution for Azure Database for PostgreSQL
  3. Introducing the Semantic Ranking Solution for Azure Database for PostgreSQL
  4. Enhanced scalability, security, and AI in Azure Database for PostgreSQL
  5. Index tuning is generally available in Azure Database for PostgreSQL
  6. Postgres horizontal scaling with elastic clusters on Azure Database for PostgreSQL Flexible server
  7. Introducing support for oracle_fdw extension in Azure Database for PostgreSQL
  8. Postgres 17 Query Performance Improvements
  9. Introducing support for Graph data in Azure Database for PostgreSQL (Preview)
  10. September 2024 Recap: Azure Database for PostgreSQL Flexible Server
  11. Azure PostgreSQL with Azure Open AI to innovate Banking Apps: Unlocking the Power of AI Extension
  12. Introducing DiskANN Vector Index in Azure Database for PostgreSQL
  13. PostgreSQL 17 Preview on Azure Postgres Flexible Server
  14. Mirroring Azure Database for PostgreSQL Flexible Server in Microsoft Fabric - Private Preview
  15. Aug 2024 Recap: Azure Database for PostgreSQL Flexible Server
  16. Configuring auto_explain for Advanced Query Analysis
  17. July 2024 Recap: Azure Database for PostgreSQL Flexible Server
  18. Optimizing Query Performance with Work_Mem
  19. Say hello to the Talking Postgres podcast
  20. June 2024 Recap: Azure Database for PostgreSQL Flexible Server
  21. Introducing new troubleshooting guides features
  22. Azure Policy Support is Generally Available for PostgreSQL Flexible Server
  23. Azure Advisor Integration with Troubleshooting Guides for enhanced performance
  24. Prevent SQL Injection attacks on your PostgreSQL servers
  25. Tuning logical replication on Azure Database for PostgreSQL – Flexible Server
  26. Ultimate Guide to POSETTE: An Event for Postgres, 2024 edition
  27. May 2024 Recap: Azure Database for PostgreSQL Flexible Server
  28. Introducing in-database embedding generation for Azure Database for PostgreSQL
  29. Gen AI simplified: The azure_ai extension now generally available on Azure Database for PostgreSQL
  30. Unleash the power of automated index tuning in Azure Database for PostgreSQL Flexible Server
  31. Spatial Workflows in Azure Database for PostgreSQL - Flexible Server
  32. What’s new with Postgres at Microsoft, 2024 edition
  33. April 2024 Recap: Azure Database for PostgreSQL Flexible Server
  34. Huge performance gains: Migrate now to Azure Database for PostgreSQL - Flexible Server
  35. About Talk Selection for POSETTE: An Event for Postgres 2024
  36. Online Migration to PostgreSQL Flexible Server on Azure from Single Server
  37. General availability of enhanced Geo-Disaster recovery with read replicas
  38. March 2024 Recap: Azure Database for PostgreSQL Flexible Server
  39. LangChain integration with Azure Database for PostgreSQL (Part 1)
  40. The serverless frontier: Announcing Azure's dual-peak serverless regions on Kilimanjaro
  41. Real-time predictions with the azure_ai extension (Preview)
  42. Calling Postgres speakers, POSETTE CFP is open until Apr 7th 2024
  43. February 2024 Recap: Azure Database for PostgreSQL Flexible Server
  44. Real-time text translation using the azure_ai extension in Azure Database for PostgreSQL
  45. Private Link based networking is now generally available in Azure PostgreSQL Flexible Server
  46. PostgreSQL Making Index creation faster
  47. Tips for tuning Postgres LIKE & ILIKE queries via pg_trgm on Azure
  48. What’s in a name? Hello POSETTE: An Event for Postgres 2024
  49. Podcast about transitioning from developer to PostgreSQL specialist, with Derk van Veen
  50. The azure_ai extension to Azure Database for PostgreSQL, definition and demo
  51. What’s new in the Postgres 16 query planner / optimizer
  52. January 2024 Recap: Azure Database for PostgreSQL Flexible Server
  53. Podcast highlights on benchmarking Postgres performance, from Path To Citus Con Episode 11
  54. Harness the Power of the Migration Service in Azure Database for PostgreSQL
  55. Azure PostgreSQL Fleet-Level Monitoring with Log Analytics and KQL
  56. Seamless Shift: Migrating from Amazon RDS for PostgreSQL to Azure Database for PostgreSQL

2023 73

  1. Highlights from podcast episode about Postgres monitoring with Lukas Fittl and Rob Treat
  2. Microsoft Defender integration Azure PostgreSQL Flexible Server to enhance your security posture
  3. November 2023 Recap: Azure Database for PostgreSQL Flexible Server
  4. My Illustrated Guide to Postgres at PASS Data Summit 2023
  5. Mastering the Move: Migrating from Azure Database for PostgreSQL Single to Flexible Server
  6. Enhance Monitoring with Azure Postgres Grafana Dashboard
  7. Azure Database for PostgreSQL: AI-Ready for Enterprise Applications in Flexible Server
  8. Multi-Region Disaster Recovery: Streamlined with New Features
  9. General Availability of PostgreSQL 16 on Azure Database for PostgreSQL - Flexible Server
  10. Introducing the azure_ai extension to Azure Database for PostgreSQL
  11. Introducing Premium SSD v2 for Azure Database for PostgreSQL Flexible Server
  12. Introducing Private Link based networking with Azure Database for PostgreSQL – Flexible Server
  13. Near-zero Downtime Scaling in Azure Database for PostgreSQL Flexible Server
  14. Highlights of Path To Citus Con podcast ep09 with Postgres experts Dimitri Fontaine and Vik Fearing
  15. Introducing Pre-Migration Validations for Single Server to Flexible Server Migration tool
  16. September 2023 Recap: Azure Database for PostgreSQL Flexible Server
  17. The Story Behind the Activity Book for Postgres
  18. Creating and Monitoring Read Replicas in Azure Postgres Flexible Server
  19. Why giving talks at Postgres conferences matters? Highlights from a podcast
  20. Episode 7 highlights of Path To Citus Con podcast w/Paul Ramsey & Regina Obe
  21. August 2023 Recap: Azure Database for PostgreSQL Flexible Server
  22. What’s new with Postgres at Microsoft (August 2023)
  23. DNS Zone linking is no longer enforced when creating Azure Database for PostgreSQL - Flexible Server
  24. Autoscaling Azure PostgreSQL Server with Automation Tasks
  25. Episode 6 highlights of Path To Citus Con podcast w/Chelsea Dole & Floor Drees
  26. July 2023 Recap: Azure Database PostgreSQL Flexible Server
  27. Understanding partitioning and sharding in Postgres and Citus
  28. Community Insights on pgBadger: A PGSQL Phriday #010 Recap
  29. PostgreSQL v15 is now Generally available in Flexible Server PostgreSQL!
  30. Say hello to Path To Citus Con, a podcast for developers who love Postgres
  31. June 2023 Recap: Azure Database for PostgreSQL Flexible Server
  32. Storage Autogrow and Online Disk Scaling in Azure PostgreSQL Flexible Server - Generally Available!!
  33. Azure PostgreSQL Multi-Resource Alerts with Metrics
  34. PGSQL Phriday #010: You're Invited to Dive into the World of pgBadger
  35. Security Hardening Best Practices for PostgreSQL Flexible Server
  36. Expose PostgreSQL tables as REST APIs with Data API Builder
  37. What’s New in Azure Database for PostgreSQL – Flexible Server
  38. Introducing Intel V5 Compute and 32 TB Storage Support on Azure PostgreSQL Flexible Server
  39. Call Stored Procedure in PostgreSQL Flexible Server from Java via JDBC
  40. Unlocking the power of Open AI and pgvector with Azure PostgreSQL and Azure Cosmos DB for PostgreSQL
  41. Idea for GPT Plugin: Citus Shard Key Selection in Postgres
  42. OpenAI/ChatGPT retrieval plugin and PostgreSQL on Azure
  43. Why should you migrate to PostgreSQL 15?
  44. Announcing support for Azure Key Vault Managed HSM with Azure PostgreSQL Flexible server
  45. April 2023 Recap: Azure Database for PostgreSQL Flexible Server
  46. Introducing Real-Time Database Availability Monitoring
  47. Azure Database for PostgreSQL : Logical Replication
  48. Empower Your Troubleshooting with Azure Database for PostgreSQL - Flexible Server Guides
  49. March 2023 Recap: Azure Database for PostgreSQL Flexible Server
  50. Query Performance Insight - Start monitoring in minutes
  51. Ultimate Guide to Citus Con: An Event for Postgres, 2023 edition
  52. Introducing support for pg_carbonara extension in PostgreSQL Flexible Server
  53. Announcing GA of Read Replica for Azure PostgreSQL Flexible Server
  54. PostgreSQL on Azure – How to choose what’s best for your app
  55. Retiring Azure Database for PostgreSQL Single Server in 2025
  56. Single Server to Flexible Server Migration tool is GA in Azure Database for PostgreSQL
  57. Failover Between Regions with Azure PostgreSQL Flexible Server without connection string changes
  58. Announcing Data API Builder (Preview) for PostgreSQL
  59. Monitoring PgBouncer in Azure PostgreSQL Flexible Server
  60. Announcing new security and observability features in Azure Database for PostgreSQL
  61. Azure PostgreSQL Flexible Server -February 2023 Feature Summary
  62. How to generate pgBadger report from Azure Database for PostgreSQL Flexible Server
  63. New PostgreSQL migration extension for Azure Data Studio now in Public Preview
  64. Major Version Upgrade in Azure PostgreSQL Flexible Server - Generally Available
  65. Monitoring Autovacuum in Azure PostgreSQL Flexible Server
  66. The CFP is open for Citus Con: An Event for Postgres 2023
  67. Azure Active Directory authentication in Azure PostgreSQL Flexible Server is now GA!
  68. Customer Managed Key feature in Azure PostgreSQL Flexible Server enters General Availability!
  69. How to access Azure PostgreSQL Flex Server from ADF Managed VNet using a Private End Point
  70. Debugging PostgreSQL CI failures faster: 4 tips
  71. Audit Logging and Microsoft Entra in Azure Database for PostgreSQL Flexible servers.
  72. Enhanced monitoring metrics for Azure Postgres Flexible Server
  73. Secure sensitive data with pgcrypto extension in Azure PostgreSQL Flexible Server

2022 26

  1. Identify and solve connection performance in Azure Postgres
  2. Customer Managed Key feature in Azure PostgreSQL Flexible Server is GA in number of Azure regions!
  3. Steps to install and setup PgBouncer connection pooling on Azure Kubernetes Services (AKS)
  4. Reducing replication lag with IO concurrency in Postgres 15
  5. Azure open-source databases enable businesses to do more with less
  6. Leverage built-in PgBouncer in Flexible Server
  7. Secure PostgreSQL Flex Server data with encryption and customer managed keys (Preview)
  8. New backup and restore enhancements in Flexible Server
  9. Ignite 2022 - Continued innovation with Azure Database for PostgreSQL flexible server
  10. How to Add More Environments to the Postgres CI
  11. Enable slow query logging in Azure database for PostgreSQL
  12. How to check logs for Azure Database for PostgreSQL
  13. Lower your total cost of ownership with Azure Database for PostgreSQL
  14. Debugging Postgres autovacuum problems: 13 tips
  15. Introducing support for Pgrouting and PLV8 extensions in PostgreSQL Flexible Server
  16. PostgreSQL v14 is now available in Flexible Server PostgreSQL!
  17. Achieve high uptime with Flexible Server PostgreSQL HA!
  18. Building IoT apps using Postgres, Citus, and Azure
  19. Secure your Java application connections to Flexible Server via JDBC and SSL
  20. Speeding up sort performance in Postgres 15
  21. Moving Postgres data 26X faster with Azure Data Factory
  22. How to benchmark performance of Citus and Postgres with HammerDB on Azure
  23. Introducing ability to allow-list extensions in PostgreSQL Flexible Server
  24. Call for speakers for Citus Con: An Event for Postgres
  25. Why give a conference talk (or, why give a Postgres talk)
  26. Deploy a connectivity dashboard for PostgreSQL Flexible Server

2021 24

  1. Create a Connectivity Dashboard for Postgres Single Server in Azure
  2. UK COVID-19 dashboard built using Postgres and Citus for millions of users
  3. Azure Database for PostgreSQL – Flexible Server is now GA!
  4. Private Networking Patterns in Azure Database for Postgres Flexible Server
  5. Introducing Private Link in Hyperscale (Citus) for Postgres on Azure
  6. Memory Tuning for workloads in PostgreSQL Flexible Server on Azure
  7. Flexible Server now supports V4 compute series in PostgreSQL on Azure
  8. How We Shipped PostgreSQL 14 on Azure Within One Day of its Release
  9. Shard rebalancing in the Citus 10.1 extension to Postgres
  10. Citus 10 is now GA in Hyperscale (Citus) for Postgres on Azure
  11. DNS configuration patterns for Azure Database for PostgreSQL - Flexible Server
  12. What’s new in Hyperscale (Citus) for Postgres on Azure (ft. read replicas)
  13. Bringing the best of Azure and PostgreSQL innovation to developers
  14. Postgres with columnar compression in Hyperscale (Citus) on Azure
  15. New Postgres superpowers in Hyperscale (Citus) with Citus 10
  16. Citus Tips for Postgres: How to alter distribution key, shard count, & more
  17. Sharding Postgres with Basic tier in Hyperscale (Citus), how why & when
  18. Speeding up recovery and VACUUM in Postgres 14
  19. Why Restarting Azure Database for PostgreSQL took long?
  20. Faster Data Migrations in Postgres
  21. Migrating database storage objects from Oracle to Postgres
  22. Citus Tips: How to undistribute a distributed Postgres table
  23. New Oracle to Postgres Migration Guide for Azure
  24. Are you running into Postgres connection issues on Azure?

2020 45

  1. Don't let collation versions corrupt your PostgreSQL indexes
  2. When to use Hyperscale (Citus) to scale out Postgres
  3. Auto start/stop Flexible Server using Azure Automation Python RunBook
  4. Azure CLI improvements for Azure Database for PostgreSQL – Single server
  5. Making Postgres stored procedures 9X faster in Citus
  6. Azure CLI & Flexible Server for Postgres: Better Together
  7. Automate Backups from Azure Database for PostgreSQL Server to Azure Storage for Long Term Retention
  8. Analyzing GPS trajectories at scale with Postgres, MobilityDB, & Citus
  9. Evolving pg_cron together: Postgres 13, audit log, background workers, & job names
  10. Migrating interactive analytics apps from Redshift to Postgres, ft. Hyperscale (Citus)
  11. Improving Postgres Connection Scalability: Snapshots
  12. What’s new in pg_auto_failover 1.4 for Postgres high availability
  13. Analyzing the Limits of Connection Scalability in Postgres
  14. What is Flexible Server in Azure Database for PostgreSQL?
  15. Introducing Flexible Server for Azure Database for PostgreSQL
  16. Diary of an Engineer: Delivering 45x faster percentiles using Postgres, Citus, & t-digest
  17. Talking about Citus & Postgres at any scale
  18. Mining for logic bugs in the Citus extension to Postgres with SQLancer
  19. Alter table column in PostgreSQL: An alternative approach
  20. Moving data with PostgreSQL COPY and \COPY commands
  21. Microsoft collaborates with Bitnami to give production-ready solutions using PostgreSQL in Azure
  22. How to securely authenticate with SCRAM in Postgres 13
  23. How to monitor bloat in Postgres with Datadog custom metrics on Azure Database for PostgreSQL
  24. Connect from Function app with managed identity to Azure Database for PostgreSQL
  25. Security & Compliance Certifications on Azure Database for PostgreSQL - Single Server
  26. Connection Pooling for Postgres with the Heimdall Proxy
  27. Postgres Tips: How to convert 2 Billion Rows to Bigint with Citus
  28. Preview - Data encryption using customer managed key for Azure Database for PostgreSQL
  29. Change data capture in Postgres: How to use logical decoding and wal2json
  30. Spatial SQL with PostGIS and Postgres: What makes spatial queries special?
  31. Introducing Postgres Projects in Azure Data Studio
  32. Using Terraform to create Private Endpoint for Azure Database for PostgreSQL - Single Server
  33. Importing spatial data to PostGIS
  34. Create a Monitoring Dashboard for Azure Database for PostgreSQL
  35. New, simpler way to sign-in to Azure Database for PostgreSQL - Single Server using Azure AD
  36. Connectivity and network security improvements for Azure Database for PostgreSQL – Single server
  37. How to configure Postgres log settings
  38. Microsoft Azure Welcomes PostgreSQL Committers
  39. Taking Postgres's temperature with these 4 system metrics
  40. QGIS + Azure Database for PostgreSQL/PostGIS
  41. Automated Query Caching with the Heimdall Proxy
  42. Take your spatial data analysis to the next level with PostGIS at Azure PostgreSQL
  43. Azure Database for PostgreSQL - Checklist for Performance
  44. Using Private Link and Point-to-Site Gateway for secure on-premise connectivity to PostgreSQL Server
  45. Introducing Private Link for Azure Database for PostgreSQL Single server

2019 35

  1. Introducing Azure Active Directory authentication for Azure Database for PostgreSQL
  2. Using the Heimdall Proxy to Split Reads and Writes for Azure Databases
  3. Accelerate SQL Performance with the Heimdall Proxy
  4. Restore your Azure Database for PostgreSQL server into a different Azure subscription, the right way
  5. Application state – I want the easiest, most trouble-free deployment for the database
  6. How Data Virtualization is making the world of data more peaceful, productive, and profitable
  7. Copy data from Azure Blob to Azure Database for PostgreSQL using Azure Data Factory
  8. Azure Database for PostgreSQL - Hyperscale (Citus) now generally available
  9. Azure Database for PostgreSQL and OSSDBs on Azure: Latest updates through Ignite 2019!
  10. Architecting petabyte-scale analytics by scaling out Postgres on Azure with the Citus extension
  11. Visit the Azure Database for PostgreSQL team at Microsoft Ignite
  12. Troubleshoot PostgreSQL: ‘An existing connection was forcibly closed by the remote host’
  13. Auto Failover with PostgreSQL 12
  14. Auditing: Know what's going on in your Postgres database
  15. Database sharding explained in plain English
  16. Bring your data to Azure Database for PostgreSQL Hyperscale (Citus) using Azure Data Factory
  17. Python + Azure Database for PostgreSQL
  18. Not all Postgres connection pooling is equal
  19. Prevent the disaster of accidental deletion for your Postgres database on Azure
  20. Performance Troubleshooting Basics on Azure Database for PostgreSQL
  21. Azure Database for PostgreSQL feature releases and blog posts over the past year
  22. Set up Pgpool-II Query Caching with Azure Database for PostgreSQL
  23. Using COPY command in Azure Database for PostgreSQL
  24. R + Azure Database for PostgreSQL
  25. New Relic integration with Azure Database for PostgreSQL
  26. Backup Azure Database for PostgreSQL to a Blob Storage
  27. Scaling out Azure Database for PostgreSQL using Foreign Data Wrappers
  28. Connection handling best practice with PostgreSQL
  29. Securing Connectivity to Azure Database for PostgreSQL
  30. Secure connectivity from On-Premise to Azure Database for PostgreSQL using Point-to-Site Gateway
  31. Create Azure Database for PostgreSQL with Initialization Script
  32. Improve Performance of Read Intensive Workloads on Azure DB for PostgreSQL using Query Caching
  33. Steps to install and setup PgBouncer connection pooling proxy with Azure DB for PostgreSQL
  34. Upgrade from Basic to General Purpose or Memory Optimized tiers in Azure Database for PostgreSQL
  35. Create a master server and read replicas in Azure Database for PostgreSQL using the Azure CLI