title

text

Нина Белявская
Нина Белявская Служба движения ГУП "Мосгортранс"
14:00 05 February
22 мин

Road public transport in Moscow analysis: from PostGIS to 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.

слайды слайды

Видео

Другие доклады

  • Kamil Islamov
    Kamil Islamov Stickeroid Ai
    22 мин

    Sequences used for business-logic implementation

    Examples of Sequences' opportunities implementations for developing business-logic powered by stored functions.

  • Игорь Косенков
    Игорь Косенков Postgres Professional
    90 мин

    Deploying a fault-tolerant PostgreSQL cluster on pacemaker

    Corosync & pacemaker is a well known solution for creating fault-tolerant clusters. Such clusters can contain 3 working nodes or 2 working nodes and one voting-only node. The cluster can be deployed on physical or virtual servers.

    This tutorial will demonstrate the process of installation and tuning of a PostgreSQL fault-tolerant cluster. You will learn that it is not so difficult as seems to be from the first glance.

  • Alexander Korotkov
    Alexander Korotkov Postgres Professional
    45 мин

    What's new in PostgreSQL 13?

    PostgreSQL 13 Feature Freeze is scheduled for April 2020. Two more commitfests are still accepting new patches. What we can say about PostgreSQL 13. It's possible that rotation rule will work so that new release wouldn't have as many new features as PostgreSQL 12 have. If even it is do, that would be good evolutionary release with a lot of medium feature and infrastructure changes, which prepares postgres for new leap. In this talk I will overview expected novelties in PostgreSQL 13. It would be more or less accurate, since there would be only one commitfest left, which results are possible to forecast.

  • Нина Белявская
    Нина Белявская Служба движения ГУП "Мосгортранс"
    22 мин

    Road public transport in Moscow analysis: from PostGIS to 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.