.png.180x180.jpg)
"Which ones are temporary here? Get down! Your time's up." Alternatives to Temporary Tables in Postgres
This talk addresses a common issue and touches a bit on application architecture. Temporary tables in database applications are typically used for several purposes.
Firstly, they are used to store intermediate results when implementing complex data processing algorithms. Secondly, in the case of stored procedures, application servers often place large datasets into temporary tables when they are too large or inconvenient to pass as parameters to stored procedures.
The handling of temporary tables in different DBMSs is implemented in various ways, which often complicates migration from these systems to Postgres.
The drawbacks of temporary tables are well-known, which leads to a reasonable desire to replace them, where possible, with other methods that can achieve the same goal. This talk focuses on alternative mechanisms provided by Postgres to solve this problem.