March 15 – 17 , 2017

PgConf.Russia 2017

Digital October, Moscow, Russia


  • более
    0 участников
  • более
    0 докладов
  • оффлайн
  • 0
    минут общения


Архив докладов

PgConf.Russia 2017
  • Egor Rogov
    Egor Rogov Postgres Professional
    90 мин

    ProBackup: fast, reliable, and incremental

    Modern state of backup tools for PostgreSQL certainly leaves some room for improvements. Standard utilities provides only basic functionality, third-party tools solve some, but not all, problems. To take backups reliably, fast, and incrementally on page level, one needs not only a backup tool, but also some support from the database server. On this tutorial we will talk about our new backup and recovery manager ProBackup, and will show it in action.

    Demonstration script:

  • Dmitry Yuhtimovsky
    Dmitry Yuhtimovsky Gilev.ru
    45 мин

    Debugging 1С code in PostgreSQL DBMS

    1. 1C:Enterprise 8 and PostgreSQL 9 interoperability 1.1 Changes in new 1C platform versions 1.2 v81c_data and v81c_index schemas 1.3 Sending 1C queries to SQL 1.4 Using 1C technological log events for PostgreSQL diagnostics
    2. Analyzing queries that affect PostgreSQL performance 2.1 A free tool for automating log parsing 2.2 Pareto principle in action 2.3 Installation and configuration of the tool 2.4 A case study of query optimization 2.4.1 An issue in a PostgreSQL query 2.4.2 Finding non-optimal operations in a query 2.4.3 Resolving inefficiencies
    3. PostgreSQL statistics for performance diagnostics 3.1 Comparing Postgres with MS SQL Server 3.2 Troubleshooting locks 3.3 Operating load diagnostics 4 Case studies by the gilev.ru team

  • Andrey Borodin
    Andrey Borodin Яндекс
    45 мин

    GiST speedup: patches, hacks and tweaks

    This report overviews some ideas and implementations to speedup different parts of generalized search trees (GiST): 1. Intrapage indexing 2. Fractal tree technology 3. Modern algorithms for spatial indexing (RR*-tree) 4.. Possible advancements of GiST API


Все доклады