Анализ движения наземного общественного транспорта Москвы: от PostGIS к MobilityDB
Moscow public transport vehicles when moving report their coordinates via GLONASS. Collected data is used for various analyses including timetable development, bottlenecks detection and planning the bus lanes. Until recently we used the PostGIS extension for this purpose but now we are switching to a new PG extension — MobilityDB — designed especially for geodata time series processing. I have compared the table size and the performance of our solution without and with MobilityDB and happy to present the results.
Слайды
Нина Белявская - Анализ движения транспорта - от PostGIS к MobylityDB.pptxВидео
Другие доклады
-
Alicja Kucharczyk Microsoft
Architecting petabyte-scale analytics by scaling out Postgres on Azure with Citus
The story about powering a 1.5 petabyte analytics application with 2816 cores and 18.7 TB of memory in the Citus cluster at the Microsoft. The Windows team measures the quality of new software builds by scrutinizing 20,000 diagnostic metrics based on data flowing in from 800 million Windows devices. At the same time, the team evaluates feedback from Microsoft engineers who are using pre-release versions of Windows updates. At Microsoft, the Windows diagnostic metrics are displayed on a real-time analytics dashboard called “Release Quality View” (RQV), which helps the internal “ship-room” team assess the quality of the customer experience before each new Windows update is released. Given the importance of Windows for Microsoft’s customers, the RQV analytics dashboard is a critical tool for Windows engineers, program managers, and execs.
-
Oleg Bartunov Postgres Professional
Как будет развиваться Postgres в ближайшие годы
A short overview of the main trends in Postgres development - both for the product itself and the community. What has changed in community goals?
-
Виктор Еремченко Miro
Отказоустойчивый кластер PostgreSQL + Patroni
I will speak about our experience in solving the fault-tolerance problem for PostgreSQL, which options we reviewed and how we chose Patroni.
I will cover solution testing, quick implementation to the production and issues we faced as well as the way we solved them.
-
Kamil Islamov Stickeroid Ai
Методы использования Sequences в бизнес-логике
Examples of Sequences' opportunities implementations for developing business-logic powered by stored functions.