Нина Белявская
Нина Белявская Служба движения ГУП "Мосгортранс"
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.

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


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

  • Антон Нечеухин
    Антон Нечеухин Miro
    90 мин

    Tool as code: testing Postgres

    At the master class, we will learn how to execute fast load tests of Postgres databases: optimizing database configurations, data structure, indexes, OS settings, etc. To do this, we will create a code, build the infrastructure for the test from it and will do the test. As a result, we get a flexible tool in the code to which you can attach any monitoring, and for which you don't have to pay a lot of money, because the environment is created in 7 minutes in an empty AWS account and destroyed after test

  • Andrey Zubkov
    Andrey Zubkov ООО "Пармалогика"
    22 мин

    Using a GiST index in solution of custom search problem

    I'll show an example of solving the problem of searching "similar" texts for one given text in big array using GiST index. The problem itself is not much important, but it is easy to understand. Using this problem as example, I'll show one of many methods of adapting GiST index for custom search problems. Maybe this talk will help you to solve other search problems.

  • O
    Oleksii Kozlov Swarm64 AS
    Mikhail Tsvetkov
    Mikhail Tsvetkov Intel
    22 мин

    Hardware acceleration options for Postgres: Intel Optane DC Persistent Memory and FPGA.

    If you care about Postgres performance, there are a number of hardware acceleration options to help with different use cases. Intel Optane DC persistent memory creates new tier in data hierarchy allowing developers to utilize performance of traditional memory combining with volume and persistency of block storage devices. Unlike traditional DRAM-only in-memory systems, where memory is small, expensive, and volatile, Intel Optane DC persistent memory makes it possible to run larger Postgres databases (terabytes) in memory for higher performance. FPGAs are integrated circuits that can be reprogrammed dynamically to accelerate a specific workload such as SQL execution and data compression. FPGA accelerators extend Postgres with hundreds of SQL reader and writer processes that work in parallel on the FPGA. It’s similar to adding hundreds new cores to boost parallel processing on your server.

  • Rustam Abdrakhimov
    Rustam Abdrakhimov ООО Форс-Телеком
    Alexander Liubushkin
    Alexander Liubushkin ООО "ФОРС Телеком"
    90 мин

    Development of WEB-applications for Postgres using the new tool - Live Universal Interface (LUI)

    Will be demonstrated in the master-class the following: 1). The benefits of declarative programming. Rapid creation of complex LUI-forms using only SQL. 2). Support for long transactions and automatic locks. An example of a wizard with a record directly in the database. 3). The multilingual fields and columns. Rapid inclusion of multilingualism in existing forms. 4). Control the coloring of data in fields and columns of the form. Typical examples. 5). Live search in input fields using the example of address input. 6). How to configure the LUI to enter and display of application-specific data. 7). Design form Master Detail with retrieving data from two different databases. 8). How end-user builds of complex data queries without using SQL.