Postgres Pro
Downloads
Home   >   mailing lists

Re: Temporary tablespaces on a RAM disk - Mailing list pgsql-general

From Daniel Westermann (DWE)
Subject Re: Temporary tablespaces on a RAM disk
Date
Msg-id ZR0P278MB0028CF70C137D7D4EBBA0802D2F60@ZR0P278MB0028.CHEP278.PROD.OUTLOOK.COM
Whole thread Raw
In response to Re: Temporary tablespaces on a RAM disk  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
Tree view
On Tue, Mar 17, 2020 at 2:49 AM Daniel Westermann (DWE) <daniel.westermann@dbi-services.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

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

Regards
Daniel

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Temporary tablespaces on a RAM disk
Next
From: "Daniel Westermann (DWE)"
Date:
Subject: Re: Temporary tablespaces on a RAM disk