Leveraging pgBadger for Effective PostgreSQL Troubleshooting (PGConf.EU 2023)

pgBadger stands as one of the most comprehensive and widely adopted tools for diagnosing issues and analyzing the current state of a PostgreSQL database. As an open-source utility that's platform-agnostic and easy to use, it offers users in-depth insights into a myriad of events occurring within their databases.

This includes visibility into the activities of the autovacuum daemon, such as the number of ANALYZE and VACUUM operations it calls, the tables affected, and the quantity of rows and pages deleted. In addition, pgBadger allows analysis of the distribution and sizes of temporary files, including the queries that generate them. Furthermore, it offers understanding into the types of locks within the system, the most frequent waiting queries, and the longest waiting ones, although it doesn't provide information about which query held a lock.

In this session, we will delve into select use cases of interpreting a pgBadger report and deciding on necessary interventions when encountering specific "red flags". Learn how to harness the potential of pgBadger within a focused scope, turning diagnostic data into actionable strategies to enhance the performance and stability of your PostgreSQL operations. This session aims to improve your PostgreSQL troubleshooting skills by providing a comprehensive understanding of specific use cases in your database management process.

Performance features in Azure Database for PostgreSQL - Flexible Server [lang:EN][video]

Join this session to learn how to take your application performance to the next level with Azure Database for PostgreSQL. Azure Database for PostgreSQL is a platform as a service solution that combines the versatility and scalability of a cloud database with the trustworthiness and familiarity of PostgreSQL. Flexible Server is a deployment in Azure Database for PostgreSQL and is perfect for app developers seeking a fast, reliable, and scalable database service to elevate their applications.

Citus Con: An Event for Postgres 2023 Sessionize Event

SQLBits 2023 - General Sessions Sessionize Event

"Troubleshooting Postgresa za pomocą pgBadgera" - SysOps/DevOps Warszawa MeetUp #52[lang:PL][video]

PgBadger to jedno z najbardziej wszechstronnych i najpopularniejszych narzędzi umożliwiających analizę problemów i obecnego stanu bazy. Co ważne - jest darmowe, łatwe w użyciu i niezależne od platformy, na której działa Postgres. Pozwala użytkownikom mieć wgląd w wiele różnych zdarzeń zachodzących w bazie danych, w tym: Vacuums, Temp Files, Locks. Na tej sesji dowiecie się, jak analizować raport pgBadgera oraz jakie zmiany należy wprowadzić, gdy zobaczycie określone "czerwone flagi".

Citus Con: An Event for Postgres Sessionize Event

Postgres Build 2021 - The Story About The Migration [lang:EN][video]

The story about a challenging PoC that proved that Postgres can achieve the same performance as Oracle Exadata. The schema that was migrated wasn’t the simplest one you might see. It was quite the opposite. The code was loaded with dynamic queries, BULK COLLECT’s, nested loops, CONNECT BY statements, global variables, and a lot of dependencies.

DataOps Poland #29 Architecting petabyte-scale analytics by scaling out Postgres on Azure and Citus

A story about powering a 1.5 petabyte internal analytics application at Microsoft with 2816 cores and 18.7 TB of memory in the Citus cluster.

The internal RQV analytics dashboard at Microsoft helps the Windows team to assess the quality of upcoming Windows releases. The system tracks 20,000 diagnostic and quality metrics, digests data from 800 million Windows devices and currently supports over 6 million queries per day, with hundreds of concurrent users. The RQV analytics dashboard relies on Postgres—along with the Citus extension to Postgres to scale out horizontally—and is deployed on Microsoft Azure.

SQL Day 2021

Beyond SQL Server – Open Source Databases on Azure

DevOpsDays Zurich 2020 Sessionize Event

FOSDEM PostgreSQL Devroom - The Story About The Migration [lang:EN][video]

The story about a challenging PoC that proved that Postgres can achieve the same performance as Oracle Exadata. The schema that was migrated wasn’t the simplest one you might see. It was quite the opposite. The code was loaded with dynamic queries, BULK COLLECT’s, nested loops, CONNECT BY statements, global variables, and a lot of dependencies.

Architecting petabyte scale analytics by scaling out Postgres on Azure with Citus [lang:EN][video]

This is the story about a Postgres PaaS service powering a 1.5 petabyte analytics application with 2816 cores and 18.7 TB of memory in the Citus cluster at Microsoft. We will discuss its architecture, features, and use case:

The Windows team measures the quality of new software builds by scrutinizing 20,000 diagnostic metrics based on data flowing in from 800 million Windows devices. At the same time, the team evaluates feedback from Microsoft engineers who are using pre-release versions of Windows updates. At Microsoft, the Windows diagnostic metrics are displayed on a real-time analytics dashboard called “Release Quality View” (RQV), which helps the internal “ship-room” team assess the quality of the customer experience before each new Windows update is released. Given the importance of Windows for Microsoft’s customers, the RQV analytics dashboard is a critical tool for Windows engineers, program managers, and execs.

Database Cloud Migrations [lang:EN][audio]

EPISODE SUMMARY
As companies look to move to the cloud, they are looking to reduce costs and improve efficiencies. One of the most common questions is whether there is a valid business case in migrating away from Oracle and SQL Server to open-source platforms such as PostgreSQL and MySQL. In this episode, we talk about the advantages and pitfalls of these options.

EPISODE NOTES
Host: Danny Keating, Global Alliances & Solutions Sales Director, Data Intensity

Guest: Alicja Kucharczyk, EMEA Global Black Belt Specialist, Microsoft

Guest: Biju Thomas, Global Oracle Practice Lead, Data Intensity

Cloud Native London - Architecting petabyte scale analytics by scaling out Postgres on Azure

This is the story about a Postgres PaaS service powering a 1.5 petabyte analytics application with 2816 cores and 18.7 TB of memory in the Citus cluster at Microsoft. We will discuss its architecture, features, and use case:

The Windows team measures the quality of new software builds by scrutinizing 20,000 diagnostic metrics based on data flowing in from 800 million Windows devices. At the same time, the team evaluates feedback from Microsoft engineers who are using pre-release versions of Windows updates. At Microsoft, the Windows diagnostic metrics are displayed on a real-time analytics dashboard called “Release Quality View” (RQV), which helps the internal “ship-room” team assess the quality of the customer experience before each new Windows update is released. Given the importance of Windows for Microsoft’s customers, the RQV analytics dashboard is a critical tool for Windows engineers, program managers, and execs.

Linux Open Alternative Day (LOAD 2020) [lang:EN][video]

Oracle to PostgreSQL migration with ora2pg

Confuse a cat - the Postgres way [lang:PL][video]

The main concepts of advanced query processing and optimization in examples

When it comes to optimization of a query not only indexes come into play. Of course modifications to data access methods are very important and often offer huge performance gain but it’s definitely not a “silver bullet”. This talk focuses on some of the most important concepts of query processing including layers above data access methods, i.e. the flow and dependencies between subqueries, the methods of writing queries and its consequences and also some “hacks” for the optimizer will be shown.

PGCONF.EU 2018

FILE SYSTEM AND VIRTUAL MEMORY TUNING FOR A ZABBIX DATABASE

PGCONF.EU 2017

"FROM MINUTES TO MILLISECONDS – TIPS AND TRICKS FOR FASTER SQL QUERIES"