Understanding Temp Files in Postgres

Photo by Kolar.io on Unsplash

Databases can feel like black boxes that hum along perfectly until suddenly they don’t. And when bad things happen with databases…they’re usually bad! One example of an error you might run into unexpectedly with your database is something about running out of temporary file space.

This is not intended to be a comprehensive look at temp files and the internals of how they work, but just to be a primer…