Re: Temporary tablespaces on a RAM disk

From: "Daniel Westermann (DWE)" <daniel(dot)westermann(at)dbi-services(dot)com>
To: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
Cc: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Temporary tablespaces on a RAM disk
Date: 2020-03-17 19:26:36
Message-ID: ZR0P278MB0028CF70C137D7D4EBBA0802D2F60@ZR0P278MB0028.CHEP278.PROD.OUTLOOK.COM
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Mar 17, 2020 at 2:49 AM Daniel Westermann (DWE) <daniel(dot)westermann(at)dbi-services(dot)com<mailto:daniel(dot)westermann(at)dbi-services(dot)com>> 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<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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Daniel Westermann (DWE) 2020-03-17 19:28:03 Re: Temporary tablespaces on a RAM disk
Previous Message Tom Lane 2020-03-17 19:22:07 Re: Temporary tablespaces on a RAM disk