PostgreSQL Diagnostics from the standpoint of a system administrator (not a DBA)

It often happens that you already have PosgtreSQL in production, but you don’t have a DBA. To demystify the PostgreSQL database, I’ll tell you how to troubleshoot various problems while working with PosgtreSQL. We will try to understand how to answer "routine" questions of a typical system administrator: - Is everything OK with the database? - What consumes DB server resources? - What to optimize first to reduce resource consumption?

VIDEO

Слайды

Dmitry Vagin Avito

22 мин

Monitoring PostgreSQL in Avito.ru, with case studies

A short talk about collecting data and monitoring database workload in Avito. Exporting metrics from stored procedures to Graphite. Collecting and visualizing pg_stat* metrics in Grafana. Case studies.

VIDEO

Материалы к докладу
Dmitry Susha ООО Испаер Системс

22 мин

Automation of migration to PostgreSQL from various databases

The report is focused on the topic of automation of migration to PostgreSQL from other databases using Ispirer Migration and Modernization Toolkit. The issues of data and SQL code migration, conversion of client applications, embedded SQL and database API will be covered, the examples of implemented projects of migration from Oracle to PostgreSQL and from Microsoft SQL Server to PostgreSQL will be given.

VIDEO

Материалы к докладу
Ivan Panchenko Postgres Professional

90 мин

JSON, JSONB, JSQuery

This tutorial is about various applied JSON usage patterns and the related PostgreSQL functionality. We will discuss data storage in the JSON format, retrieving, changing, and searching such data, JSON features for simple SQL queries, as well as using JSON in stored procedures in different languages. You’ll get hands-on experience with some of the discussed problems on the provided virtual machines.

Материалы к докладу
Oleg Alekseev МойСклад

22 мин

Semiautomatic database schema conversion in MoySklad

MoySklad online service includes important component - semiautomatic database conversion framework. Its history and supported conversions are subject of this speech.

VIDEO

Материалы к докладу