Is it possible to set the location of temp file creation for a Postgresql backend (ver 9.3.10)?
Here's my scenario: my Postgresql DB resides in a dedicated VM with Ubuntu 14.04 OS. My VM comes with 200GB of temporary high-performance SSD storage provided by my infrastructure provider, meant for short-term storage for applications and processes. Here's how it looks like:
Filesystem Size Used Avail Use% Mounted on
/dev/sdb1 221G 9.9G 200G 5% /mnt
I'm running low on disk space, and have to run some analytical queries that can take me to disk full due to the temporary files creation.
Apart from taking measures like deleting log entries to release more space or setting
temp_file_limit in postgresql conf, I'm also interested in knowing whether I can set the location for temp files. After all, I have 220GB available for these kind of scenarios, so do want to put them to good use (swap space is set here too).
An illustrative example of how I can set this up would be very helpful since I'm a neophyte DBA.