![Dmitry Yuhtimovsky Dmitry Yuhtimovsky](/media//2017/01/26/DmYukhtimovsky_900.jpg.180x180.jpg)
Debugging 1С code in PostgreSQL DBMS
- 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
Слайды
Видео
Другие доклады
-
Dmitry Lebedev BestPlace
Researching GIS data with PostGIS and adjacent toolset
Nowadays one can make a decent urban research based simply on public datasets, making interesting and unexpected insights. In the presentation, I'll show examples of these calculations in PostGIS, the industry standard de-facto.
But just PostGIS is not enough. You need tools to import, verify and visualize the data. It's critically important to visualize the data live, to debug your calculations and shorten iterations. I'll describe all these steps:
- Collecting the data: public API, OpenStreetMap; direct user input.
- 3rd party APIs for calculations.
- Visualization of GIS and other sorts of data: QGIS, Matplotlib, Zeppelin integrated with PostGIS.
- Debugging the calculations: live visualization (Arc, QGIS, NextGIS Web)
- Scripting and minimizing the chores: Makefile, Gulp
-
Dmitry Grebenshchikov Диасофт Платформа
-
Dmitry Vagin Avito
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
-
Igor Chizhevskiy НИИ "Восход"Илья Космодемьянский Data EgretИван Богданов НИИ "Восход"Sergey Korolev МЦСТStanislav Merzlyakov ФГБУ НИИ "Восход"Dmitry Pogibenko ФГБУ "НИИ Восход"
Voskhod PostgreSQL on Elbrus
Practical experience of carrying out import substitution with using PostgreSQL in government information system including not only the free software, but also the Russian hardware (Elbrus servers and other).
VIDEO