Илья Космодемьянский
Илья Космодемьянский Data Egret
15:00 17 March
45 мин

Linux IO internals for PostgreSQL administrators

Input-output (IO) performance issues have been on DBAs’ agenda since the beginning of databases. The volume of data grows rapidly and time is of an essence when one needs to get necessary data fast from the disk and, more importantly, to the disk.

For most databases it is relatively easy to find checklist of recommended Linux settings to maximize IO throughput and, in most cases, this checklist is indeed good enough. It is however essential always to understand how the optimisation of those settings actually works, especially, if you run into corner cases.

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

  • Stanislav Merzlyakov
    Stanislav Merzlyakov ФГБУ НИИ "Восход"
    Илья Космодемьянский
    Илья Космодемьянский Data Egret
    Igor Chizhevskiy
    Igor Chizhevskiy НИИ "Восход"
    Dmitry Pogibenko
    Dmitry Pogibenko ФГБУ "НИИ Восход"
    Sergey Korolev
    Sergey Korolev МЦСТ
    Иван Богданов
    Иван Богданов НИИ "Восход"
    45 мин

    Voskhod PostgreSQL on Elbrus

    Practical experience of carrying out import substitution with using PostgreSQL in government information system including not only the free software, but also the Russian hardware (Elbrus servers and other).


  • Peter Gribanov
    Peter Gribanov
    22 мин

    1C:Enterprise business platform: working with PostgreSQL

    "1C:Enterprise" is the most popular in Russia/Eastern Europe business applications development framework supports PostgreSQL for 10+ years. We'll review some cases and pecularities of 1C and PostgreSQL tandem.

  • Aleš Zelený
    Aleš Zelený Česká spořitelna a.s.
    45 мин

    PostgreSQL introduction for Oracle DBA

    This talk is intended for Oracle DBAs whose are considering to start using PostgreSQL as another RDBMS engine in their DB portfolio or for PostgreSQL DBAs, who wants to learn some of similarities and differences between Oracle and PostgreSQL. This talk is not intended to be a migration guideline neither advocating one platform over another. General database structure overview for both platforms will be compared in terms of memory configuration parameters; logical to physical structure as well as we’ll touch some security point of view and backup & recovery tools available. Oracle container databases are not covered. The talk want’s to help create a bridge for DBA and avoid some frustrations at the first Oracle DBA step to discover, learn and start using PostgreSQL as reliable fully functional database.


  • Dmitry Susha
    Dmitry Susha ООО Испаер Системс
    22 мин

    Automation of migration to PostgreSQL from various databases

    The report is focused on the topic of automation of migration to PostgreSQL from other databases using Ispirer Migration and Modernization Toolkit. The issues of data and SQL code migration, conversion of client applications, embedded SQL and database API will be covered, the examples of implemented projects of migration from Oracle to PostgreSQL and from Microsoft SQL Server to PostgreSQL will be given.