title

text

Антон Нечеухин
Антон Нечеухин Miro
16:30 03 February
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

Материалы к докладу

Слайды

Видео

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

  • Teodor Sigaev
    Teodor Sigaev Postgres Professional
    Anton Doroshkevich
    Anton Doroshkevich ИнфоСофт
    45 мин

    "The world 1C" waiting for PostgreSQL

    One of the most widespread branches of PostgreSQL distribution in Russia is 1C. In the report I would like to share thoughts about what is missing in PostgreSQL according to 1C

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

  • 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.

  • Pavel Stehule
    Pavel Stehule freelancer
    45 мин

    The performance problems related migrations from PL/SQL to PL/pgSQL

    Porting applications from Oracle to Postgres is common work today. Unfortunately it is not without problems. In presentation I'll try to show the basic performance problems related to differences between Oracle and Postgres and PL/SQL and PL/pgSQL.