![Dmitry Vagin Dmitry Vagin](/media/2017/01/23/IMG_20161219_120401-02.jpeg.180x180.jpg)
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
Слайды
Другие доклады
-
Jasonysli Tencent
How Tencent uses Postgres-XC for their high volume WeChat payment system
Tencent, based in China, is one of the world's largest companies in the social networking space. This talk discusses how Tencent modified the code of Postgres-XC to meet their internal payment system requirements
-
Darafei Praliaskouski Juno
PostGIS for moving targets
PostGIS enables spatial processing in Postgres. Usually PostGIS is used for planar euclidean calculations, but real world adds time, ambiguity and uncertainty. We'll have a look on making a thousand of cars move smoothly in real time on OpenStreetMap base map.
VIDEO
-
Philip Delgyado ООО «Лектон»
Complex structures without ORM
I love complex knowledge domains, strong typing in applications, and 3NF, but I hate ORM. That is why I’ve been actively storing serialized structures in JSON fields (even before the JSON type was introduced). In this talk, I will tell you about some specifics of storing complex structures within DBMS fields, what problems can arise, and how to cushion the blow.
VIDEO
-
Kamil Islamov Stickeroid Ai
Postgresql Functions and ORM cooperation at Django example
We will discuss some tricks and patterns while developing web-application architecture based on ORM technology with Postgresql functions implementation with Python Django as an example. Also we will consider some ways of building the business logic inside a database with keeping Django framework opportunities and implementation of it's built-in admin panel.
VIDEO