title

text

September 25 , 2023

PGConf.SPB 2023

  • more than
    0 participants
  • 0 speakers
  • 0
    minutes of conversation
  • 24 talks
  • offline
    format

Talks

Talks archive

PGConf.SPB 2023
  • Anton Doroshkevich
    Anton Doroshkevich InfoSoft

    I have been working with 1C on PostgreSQL for 6 years, and the DBMS has changed significantly since I started. In this presentation, I'm going to cover the progress it has made. The users will, just as always, claim that this is not enough. So in addition to milestones and achievements, I'll tackle the possible feature requests from the maintenance viewpoint and explain some workarounds.

  • Dmitry Vasilyev
    Dmitry Vasilyev PostgresPro

    In this talk, I will explain how you can organize account management in a microservice environment: organization of a role model, authentication via SSO and cross-service authentication.

  • Vladimir Sitnikov
    Vladimir Sitnikov

    A talk on how regular™ indexes work in PostgreSQL. The talk will be extremely useful for those who are starting to work with databases, and for those who have worked with them but have forgotten. If the talk hits the golden picks of "must-see onboarding developer", then the goal is achieved.
    We will tackle the following subtopics:
    - How an index can speed up search;
    - Should we index WHERE conditions;
    - Should we index ORDER BY statements;
    - Should we index foreign keys;
    - What to do if search pre-assumes multiple conditions;
    - Which column order should be specified in an index;
    - Cases when index causes a slow-down and how to reduce its impact on the app.

  • Владимир Хаймин
    Владимир Хаймин VTB

    Recently, one of the most common migration methods has become migration using the free ora2pg tool. However, many note the extremely low performance of this tool, especially when it comes to databases of 1 Terabyte and above. This presentation describes how to significantly speed up database migration using oracle_fdw alone or in combination with ora2pg.

All talks

Partners

PGConf.SPB 2023

Informational

Partner