| commit | 29b493f8859f1ce0eeadaba75462006499f6f26d | [log] [tgz] |
|---|---|---|
| author | danielhanrahan <daniel.hanrahan@est.tech> | Thu Mar 02 23:27:09 2023 +0000 |
| committer | Daniel Hanrahan <daniel.hanrahan@est.tech> | Tue Mar 07 15:15:20 2023 +0000 |
| tree | b067f76614053d92c8238318b49b834bf58a7e38 | |
| parent | f0f4fd810c9a249d78def4c2f10356fceb864b1f [diff] |
Drop temp table when transaction finishes By default, temp tables are persisted until the end of the session. This causes "Out of shared memory" errors in the database, which then auto-vacuums the orphaned temp tables to free memory. To fix this, we drop temp tables when the transaction finishes, using ON COMMIT DROP. Issue-ID: CPS-1533 Signed-off-by: danielhanrahan <daniel.hanrahan@est.tech> Change-Id: Iac47d85e9621531a4a95b99c4becc8cc95242721