Postrelease
Talks
Talks archive
-
Ivan Panchenko PostgresProA summary of what the Postgres Professional company has achieved in its two-year history:
- Our achievements in PostgreSQL development.
- What is the Russian Postgres Pro DBMS, and how is it related to PostgreSQL?
- What is Postgres Pro Enterprise, and why Enterprise?
- What about trainings and certification?
VIDEO
-
Pavel Luzanov PostgresProDebugging, profiling, and tracing of the executed commands play an important role in development of any applications. This is also true for developing stored procedures in DBMS.
PostgreSQL offers various tools (both built-in and external) for these purposes.
In this talk, we will provide an overview of the available tools and their advantages and disadvantages, as well as a detailed demo of their use cases.
This talk is a part of a basic course for backend application developers (DEV1), which “Postgres Professional” company plans to announce in the near future.
-
Sergey Mirvoda Octonica, UrFUExperience we've got after 5 years of developing, deploying and improving BI system http://colibri365.ru used in government. I would talk about government IT reality and our way over it. Postgres performance improvements, using of latest features, overwriting of user generated queries to help query optimizer and other tweaks and hacks to tackle limited hardware problems. These lead us to number of computer science papers and (now committed) patches to Postgres (see Andrey Borodin talks for details).
VIDEO
-
Dmitry Yuhtimovsky Gilev.ru- 1C:Enterprise 8 and PostgreSQL 9 interoperability 1.1 Changes in new 1C platform versions 1.2 v81c_data and v81c_index schemas 1.3 Sending 1C queries to SQL 1.4 Using 1C technological log events for PostgreSQL diagnostics
- Analyzing queries that affect PostgreSQL performance 2.1 A free tool for automating log parsing 2.2 Pareto principle in action 2.3 Installation and configuration of the tool 2.4 A case study of query optimization 2.4.1 An issue in a PostgreSQL query 2.4.2 Finding non-optimal operations in a query 2.4.3 Resolving inefficiencies
- PostgreSQL statistics for performance diagnostics 3.1 Comparing Postgres with MS SQL Server 3.2 Troubleshooting locks 3.3 Operating load diagnostics 4 Case studies by the gilev.ru team
Photos
Photo archive