title

text

Yury Zhukovets
Yury Zhukovets
18:25 20 June
22 min

Temporary tables as a legacy of the transition from MS SQL. Problems, optimization, approaches

Usage of temporary tables in PostgreSQL causes additional issues like high server resources consumption and low query performance. However, sometimes you need to rely on them especially when you need to migrate your code from MS SQL, and your initial code employed them, and you had some logic implemented at the database level. This talk covers issues related to usage of temporary tables when migrating from MS SQL, and the ways to resolve them using built-in PostgreSQL features based on the scenarios contained in the code.

Slides

Жуковец.pptx

Video

Slides are available to logged-in participants

Other talks