On Tue, 2020-03-17 at 09:49 +0000, Daniel Westermann (DWE) wrote:
> is someone using temporary tablespaces on a RAM disk ? Any experiences with that?
> I did some quick tests and checked the archives but could not find any information that either confirmed it is a bad
ideanor the opposite.
Taking a step back, wouldn't it be better to increase "work_mem"
and "temp_buffers" and set "temp_file_limit", so that temporary
files are avoided whenever possible and temporary tables are cached?
Then essentially you are using the same memory for the same purposes,
but in a supported fashion.
Yours,
Laurenz Albe