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…

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store