Skip to content

Instantly share code, notes, and snippets.

View varun-dhawan's full-sized avatar
🐘
https://data-nerd.blog/

Varun Dhawan varun-dhawan

🐘
https://data-nerd.blog/
View GitHub Profile

2023 - PostgreSQL - Popularity

1. Stackoverflow Developer Survey 2023 - Databases

Article Source

image

2. DB-Engines Ranking 2023

Article Source

Add color to GitHub's README.md file

  • #f03c15 pending
  • #c5f015 completed
  • #FFA500 in-progress
  • #1589F0 #1589F0
title description ms.service ms.subservice ms.topic ms.author ms.date
Query Performance Insights
High level spec doc
postgresql
flexible-server
conceptual
varundhawan
1/3/2023
title description ms.service ms.subservice ms.topic ms.author ms.date
Azure Database for PostgreSQL Flexible Server - DB-is-Alive metric (Preview)
Metrics to monitor database availability
postgresql
flexible-server
conceptual
varun.dhawan
1/1/2023
title description ms.service ms.subservice ms.topic ms.author ms.date
Azure Database for PostgreSQL Flexible Server - Autovacuum metrics (Preview)
Metrics to monitor Auto Vacuum
postgresql
flexible-server
conceptual
varun.dhawan
12/01/2022
title description ms.service ms.subservice ms.topic ms.author ms.date
Azure Database for PostgreSQL Flexible Server - PgBouncer metrics (Preview)
Metrics to monitor PgBouncer
postgresql
flexible-server
conceptual
varun.dhawan
11/01/2022

2022 - PostgreSQL - Popularity

1. Stackoverflow Developer Survey 2022 - Databases

Article Source

image

2. Cloud Native Computing Foundation Technology Radar 2022 - Database Storage

Article Source

Azure Database for PostgreSQL Flexible Server - Logging

1. Logs Analytics

// Find Errors
// Search for errors in the last 6 hours.
// To create an alert for this query, click '+ New alert rule'
// Blog - https://techcommunity.microsoft.com/t5/azure-database-for-postgresql/how-do-i-check-logs-for-azure-database-for-postgresql/ba-p/3618983
AzureDiagnostics

PgBouncer - Benchmarking

What is PgBouncer?

PgBouncer is an open-source, lightweight, single-binary connection pooler for PostgreSQL. It can pool connections to one or more databases (on possibly different servers) and serve clients over TCP and Unix domain sockets. The primary benefit of PgBouncer is to improve idle connections and short-lived connections at the database server.

When enabled, PgBouncer runs on port 6432 on your database server. You can change your application’s database connection configuration to use the same host name, but change the port to 6432 to start using PgBouncer.

PgBouncer_Compare

PgBouncer in Azure Database for PostgreSQL Flexiable Server

title description ms.service ms.subservice ms.topic ms.author ms.date
Azure Database for PostgreSQL Flexible Server Enhanced metrics - Preview
List of new metrics
postgresql
flexible-server
conceptual
varun.dhawan
10/13/2022