Профессиональный постгрес
The famous Russian PostgreSQL developer Oleg Bartunov will open the conference with his report on how and why PostgreSQL has turned from an open source university project into modern industrial grade database.
Слайды
Видео
Другие доклады
-
Stepan Danilov РТ Лабс
Оптимизация оптимизированного и не очень
I would like to share my experience in optimization queries in PostgreSQL of RMIS (Regional Medical Information System).
-
Piotr Jarmuż Allegro sp. z.o.o
Хакинг с Postgres 11 - pg_threads
My presentation is about writing extensions in Postgres. I have written pg_threads that implements simplified POSIX thread API inside Postgres database. It adds a new powerful abstraction giving database developers new opportunities for writing parallel code thus taking advantage of multicore CPUs. There is an extra API for transactional and non-transactional IPC between threads. I also have an example application that takes advantage of this new API that scales linearly even across 2 nodes. The presentation is with live working demo using vagrant project with 2 VMs running Ubuntu and 2 Postgres 11 databases.
-
Nikolay Ryzhikov Health SamuraiММарат Сурмашев Health Samurai
Эксплуатация JSONB
JSONB in PostgreSQL has interesting properties for design and development of business systems with heavy domain, helping to fight against complexity and variability. We will discuss the trade-offs of the JSONB approach. Using an open source project for Health IT - fhirbase we will:
- load synthetic medical data into PostgreSQL
- learn how to search and index this data (gin, jsquery, json-knife)
- use JSON aggregation to build complex queries (GraphQL)
- see how this data can be modified and validated
- discuss architecture consequences of JSONB usage
Technical requirements:
- docker
- docker-compose
-
Ivan Muratov ООО "Первая Мониторинговая Компания"
PostgreSQL + PostGIS + TimescaleDB - хранилище для систем мониторинга транспорта
PostgreSQL + PostGIS + TimescaleDB is a ready-to-use symbiosis from a reliable RDBMS, a powerful set of geographical objects and calculations, and work with time-series data. This bundle perfectly solves the problem of storing telemetry, while leaving the whole PostgreSQL ecosystem in your hands.