title

text

Максим Милютин
Максим Милютин Wildberries
Dmitry Ivanov
Dmitry Ivanov Postgres Professional
16:15 07 February
45 мин

Vanilla and external partitioning in PostgreSQL

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

Слайды

Видео

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

  • Alexander Pogodin
    Alexander Pogodin Корпорация ПАРУС, МГОТУ
    A
    Alexander Pankratov НПЦ Парус
    45 мин

    Migration Technology of client-server applcations from Oracle to PostgreSQL: Principles, approaches and features.

    The report reviews approaches and implementattion options for the migration of Parus-Budget 8 client-server application from the Oracle Database platform to the PostgreSQL platform without changing the client application for Desktop and the Web. The proposed solution allows to make transparent transition of the existing users' workplaces.

  • Egor Rogov
    Egor Rogov Postgres Professional
    90 мин

    Tutorial: More indexes, good and various

    "And telling GIN from SP-GIST was quite beyond his wit, we found", said the classic. Can you? This masterclass is about not-so-often used index types (compared to conventional B-tree) which however can do a great job for you. We will look into internal mechanics of these indexes and discuss cases where they can be successfully applied. Also we will talk about some peculiarities of PostgreSQL index access. To spend time efficiently, listeners are required to have basic knowledge of PostgreSQL and should be used to read plans of simple queries.

    Materials of the master class

    Backup copy of the database with demo data can be downloaded here:

  • Sergei Starikov
    Sergei Starikov Кнопка
    Konstantin Khomyakov
    Konstantin Khomyakov Кнопка
    45 мин

    How to stop being afraid of stereotypes when choosing DBMS for 1C

    «KNOPKA» («The button»), the largest outsourcing of accounting, will tell you about your experience of transferring 500Gb of 1C Fresh databases to PostgreSQL. The report touches on the choice of DBMS and the fight against stereotypes, where we started and how developed the use of PostgreSQL, the approaches to backup and recovery of information security, our current performance of DBMS and 1C, a look into the future. Let us share why we believe that 1C + PostgreSQL is simple, reliable and fast.

  • Dmitriy Pavlov
    Dmitriy Pavlov Arenadata
    45 мин

    How to train your Greenplum

    In the pitch I will talk about the most important nuances of deployment and operations of the distributed analytical open-source database based on PostgreSQL - Greenplum. I will analyze the typical mistakes in its use, give the best practices and warn about bottlenecks.