Hi Laurenz, >From: Laurenz Albe <laurenz.a...@cybertec.at> >Sent: Tuesday, March 17, 2020 20:50 >To: Daniel Westermann (DWE) <daniel.westerm...@dbi-services.com>; >pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org> >Subject: Re: Temporary tablespaces on a RAM disk
>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 idea nor 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? I don't think you can avoid that for all cases, especially when working with large data sets. That was one of the reasons for my initial question. >Then essentially you are using the same memory for the same purposes, >but in a supported fashion. Agreed. Regards Daniel
