• Photos
  • Schedule
  • Talks
  • Speakers
  • Contacts
  • F.A.Q.
  • En Ru

    Alexey Lustin

    Alexey Lustin Silverbulleters

    5 July

    Tutorial

    Turning to Postgres for 1C: overcoming the fears

    During the tutorial we will explore the following cases:
    - discovering troublesome areas using 3rd party extensions made by the PG community;
    - debugging algorithms in Vagrant environments prior to placing them in production;
    - using Jenkins to run performance degradation checks on the existing algorithms;
    - exploring various extensions for the out-of-the-box PostgreSQL that facilitate productivity of 1C systems, including search for "hypothetical" indexes;
    - handling backup & recovery with Barman;
    - troubleshooting problematic queries and formulating approaches toward refactoring;
    - studying how proper mount points in the structure of a PG cluster influence performance of 1C.

    And for dessert — how to use Docker and Flocker for 1C-based information systems.

    During the tutorial we will explore the following cases:
    - discovering troublesome areas using 3rd party extensions made by the PG community;
    - debugging algorithms in Vagrant environments prior to placing them in production;
    - using Jenkins to run performance degradation checks on the existing algorithms;
    - exploring various extensions for the out-of-the-box PostgreSQL that facilitate productivity of 1C systems, including search for "hypothetical" indexes;
    - handling backup & recovery with Barman;
    - troubleshooting problematic queries and formulating approaches toward refactoring;
    - studying how proper mount points in the structure of a PG cluster influence performance of 1C.

    And for dessert — how to use Docker and Flocker for 1C-based information systems.

    The tutorial consits of 4 sections:
    - review of the necessary software that has to be installed on computers of 1C maintenance engineers and performance experts, and the order in which it should be applied;
    - classic 1C behavioural patterns and their visualisation with pgBadger;
    - troubleshooting of problematic queries in order to formulate approaches toward refactoring;
    - influence that versions of PG and the platform cast on durability of the production environment.

    PostgreSQL


    10

    Back to the list of talks

    Buy tutorial:

    Price:
    Enter your e-mail and we will send you payment details soon.