title

text

Artemy Ryabinkov
Artemy Ryabinkov Avito
17:00 06 February
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.

Слайды

Видео

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

  • Teodor Sigaev
    Teodor Sigaev Postgres Professional
    22 мин

    Less known but worthwile PostgreSQL extensions

    Postgres is known for it extensibility, which made it the universal database, that means it can meet the requirements of practically any project. Many extensions are well-known and widely used, for example, PostGIS extension - de-facto standard of open source GIS, hstore - an extension for storing and manipulation of arbitrary key/value pairs. I will talk about less known but useful PostgreSQL extensions, which provides a new functionaliy and/or improve the performance of PostgreSQL.

    PostgreSQL was designed to be extensible, it provides an API to application developers to extend PostgreSQL functionality and/or improve the performance for specific data and workloads. It is important that there is no need of having expertise of core developers, and these new functionality could be added online without restarting of database server. Application developer can create various database objects, such as functions, data types, operators, indexes, and even new access methods.

    I will present my choice of two extensions out of hundreds:

    vops - greatly improves the performance of Postgres for OLAP queries using vector operations, pg_variables - provides session variables for storing scalars and relations, useful for generating reports on read-only replicas.

  • Boris Yeshchenko
    Boris Yeshchenko Commvault
    22 мин

    Manage and Protect your PostgreSQL data with Commvault

    Reliable backup and recovery, at enterprise level for the PostgreSQL environment. No more traditional backups. CBT (Change Block Tracking) technology is the next generation incremental backup. Faster than snapshots, CBT back up blocks that change, not all of your data, reducing server and network traffic and eliminating the need for traditional backups. Benefits: • Data protection mode close to Real-Time • Update with ease

  • Artem Ivanov
    Artem Ivanov Atos IT S&S
    Alexey Ignatov
    Alexey Ignatov Postgres Professional
    22 мин

    Migration to PostgreSQL/Postgres Pro on multi-core Bull servers. With your own hands-on experience.

    To migrate to a PostgreSQL/Postgres Pro we need multi-core servers to be carefully tuned for correct parallelism. What settings make multi-terabyte installations work fast and correctly?

    We will share our PostgreSQL/Postgres Pro on BullSequana S and Bullion S servers testing experience.

      The features of this hardware platform which are crucial for high-loaded configurations
    • Multi-core Scale-up servers and PostgreSQL/Postgres Pro
    • Results of stress testing of PostgreSQL/Postgres Pro running on the equipment.
  • Oleg Bartunov
    Oleg Bartunov Postgres Professional
    45 мин

    Professional Postgres

    The famous Russian PostgreSQL developer Oleg Bartunov will open the conference with his report on how and why PostgreSQL has turned from an open source university project into modern industrial grade database.