title

text

Andrey Zubkov
Andrey Zubkov ООО "Пармалогика"
13:00 05 February
22 мин

Using a GiST index in solution of custom search problem

I'll show an example of solving the problem of searching "similar" texts for one given text in big array using GiST index. The problem itself is not much important, but it is easy to understand. Using this problem as example, I'll show one of many methods of adapting GiST index for custom search problems. Maybe this talk will help you to solve other search problems.

Материалы к докладу

Слайды

Видео

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

  • Алексей Лесовский
    Алексей Лесовский PostgreSQL Consulting LLC
    45 мин

    PostgreSQL Scaling Usecases

    Today no one is surprised by cloud infrastructure anymore, but not all its components are easy to deploy in cloud. For example, the database is always very demanding in terms of performance and resources. Scaling and fault tolerance are the most acute problems, that's why we have been observing rapid development of alternative DBMS in the recent years. However, traditional relational DBMS have already accumulated a lot of various features, so they often remain the first choice. Besides, they are constantly evolving and offer a wide variety of scaling tools. I will mainly speak about PostgreSQL, when you should consider scaling, and how to do it right.

    We will touch upon the following topics:
    - Streaming replication and balancing read/write workloads
    - Logical replication and data sharding
    - High availability and fault tolerance

    This talk should be interesting to DBAs, system administrators, team leads, infrastructure architects, as well as wider audience dealing with PostgreSQL.

  • Максим Милютин
    Максим Милютин Ozon
    90 мин

    Patroni and Stolon: Installation and failure processing

    Patroni and Stolon are two of the most popular and advanced solutions for orchestrating PostgreSQL and ensuring auto-failover for clusters with the Leader-Followers configuration. However, engineers who migrate from good old tools like Corosync&Pacemaker or built-in solutions of other DBMS often run into issues when installing these tools and figuring out the purpose of each component.
    In this tutorial, we will go through a typical installation procedure of Patroni and Stolon clusters on virtual machines (not in containers), as well as review their behavior in case of various infrastructure failures. The whole process will be demonstrated on three vagrant virtual machines with pre-built images. You can follow along on your own system if you set up the required environment.

  • Pavel Luzanov
    Pavel Luzanov Postgres Professional
    45 мин

    PostgreSQL Certification Program: questions and answers.

    In May 2019 «Postgres Professional» launched the PostgreSQL Certification Program. Now you can not only get training in our courses, but also confirm your knowledge by passing an appropriate set of tests.

    In this presentation, I will share the results of the first months of the program and answer the most frequently asked questions:

    Where can I get information about the certification program?
    PostgreSQL or Postgres Pro certification?
    Certificates for PostgreSQL version 10. When will you upgrade to the current version?
    Do I have to attend training centers?
    Can I pass the test remotely? Not in Moscow?
    Is it possible to take several tests at once in one day?
    How to prepare for the test? Are there any examples of training questions?
    During the test I got an incorrect question, what should I do?
    How to find out exactly which questions the answers were not correct?
    When can I retake after an unsuccessful attempt?
    How to appeal the test results?