Talks
Talks archive
-
Anton Doroshkevich InfoSoftI 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.
-
Vladimir SitnikovA 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. -
Mansur Galiev Maxim technologyWe'll talk about the tool we created, which monitors changes in the database and creates scripts for migrations of selected objects both interactively and automatically.
-
Boris Pischik PostgresPro
Aleksandr Kotin PostgresProWe will present adaptive query optimization techniques and key capabilities of the new version of AQO and SR_PLAN extensions.
Photos
Photo archive