Finding PostgreSQL temporary_file problems with tail_n_mail

(Greg Sabino Mullane) PostgreSQL does as much work as it can in RAM, but sometimes it needs to (or thinks that it needs to) write things temporarily to disk. Typically, this happens on large or complex queries in which the required memory is greater than the work_mem setting.

Read More - Register for Free Membership