Analysis of troublesome queries as a means of recurrent refactoring of 1C code

Alex Lustin

SilverBulleters, LLC


  1. Principles of searching for troublesome queries in PostgreSQL.
  2. Evaluation of hypothetical indexes and their impact on query plans.
  3. The most common errors in 1C-programming.
  4. Basic methods of code refactoring, taking into account the features of PostgreSQL.
  5. Storing analytical information from the PostgreSQL log to assess the quality of refactoring

Slides →

Video available to conference participants only. Account