Re: Temporary tablespaces on a RAM disk

["Daniel Westermann (DWE)" <daniel.westermann@xxxxxxxxxxxxxxxx>]

On Tue, Mar 17, 2020 at 2:49 AM Daniel Westermann (DWE) <daniel.westermann@xxxxxxxxxxxxxxxx> 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.

>There is a nice big bold warning callout in the documentation that covers this explicitly.

>

>https://www.postgresql.org/docs/12/manage-ag-tablespaces.html

I know, I am talking about temp_tablespaces only, so temporary objects like temporary tables, sorts, .etc.

Regards

Daniel