Skip to main content
1 vote
Accepted

PostgreSQL: What are different operations make the use of Temp files?

VACUUM and ANALYZE shouldn't create temporary files. First of all, the statistics from pg_stat_database need not be 100% accurate. Second, pg_stat_database.temp_bytes measures the size of temporary ...
Laurenz Albe's user avatar
  • 53.4k

Only top scored, non community-wiki answers of a minimum length are eligible