title

text

Alex Lustin
Alex Lustin SilverBulleters, LLC
16:00 05 February
22 мин

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

  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

Слайды

Видео

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

  • Peter Gribanov
    Peter Gribanov
    22 мин

    1С:Enterprise and PostgreSQL

    • 1С: as a cross-platform business application development environment
    • 1С and PostgreSQL together since 2006
    • 1C How to work with 1С on PostgreSQL in 1cFresh cloud service
    • What major improvements in 1С:platform make work with PostgreSQL more efficient.

  • Joshua Drake
    Joshua Drake Command Prompt, Inc.
    45 мин

    The Power of Logical Replication

    One of the most soft after features of Postgres v10 is logical replication. In this presentation we will cover what Logical Replication is, how it compares to Binary (Streaming Replication), how Logical Replication works, configuring Logical Replication, Logical Replication limitations, gotchas, security and management. We will also discuss potential deployed architectures with Logical and Binary Replication and some neat features of the underlying technology.

    At the end of this presentation an attendee with a reasonable understanding of how to manage Postgres will be able to configure Logical replication for use.

  • Stepan Danilov
    Stepan Danilov РТ Лабс
    22 мин

    Optimization of optimized and not quite

    I would like to share my experience in optimization queries in PostgreSQL of RMIS (Regional Medical Information System).

  • Artemy Ryabinkov
    Artemy Ryabinkov Avito
    22 мин

    Best Practices and Practical Nuances when working with Postgres using Go

    In my talk I'll tell you about practices of working with Postgres in the Go-services. I’ll describe general advantages and disadvantages of the basic tools that are commonly used when working with Postgres using Go. Of course, we will touch on the nuances that need to be taken into account when your services are running inside the Kubernetes. I will also talk about Avito’s experience in providing a database of product’s developers. This presentation will be of interest to developers who want to avoid problems when working with Postgres, and will be useful to DBA who want to know what difficulties customers face in their database.