May 2018
Intermediate to advanced
576 pages
30h 25m
English
Because temporary files are not as carefully preserved as ordinary tables (this is actually one of the benefits of temporary tables, as less bookkeeping makes them faster), it may sometimes happen that a system crash leaves a few temporary files, which can (in the worst cases) take up a significant amount of disk space.
As a rule, you can clean up such files by shutting down the PostgreSQL server and then deleting all files from the pgsql_tmp directory.