Manage Postgresql Temp Files
Опубликовано: 05 Август 2026
на канале: Postgres Pilot
на канале: Postgres Pilot
0
This video provides a practical guide on how to configure and manage temporary files in PostgreSQL at both the database and role levels.
It walks through the process of creating a dedicated temporary tablespace and setting the temp_tablespaces parameter to route temporary files for specific users or databases to that new location.
It also highlights the necessary step of granting CREATE privileges to the role to ensure the tablespace can be utilized properly.
Finally, the video demonstrates how to monitor this setup in action by executing a large bulk insert and tracking the temporary files as they spill to disk using the pg_ls_tmpdir function