Re: Temporary tablespaces on a RAM disk

>Laurenz Albe writes: >> On Tue, 2020-03-17 at 19:57 +, 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 eith

Re: Temporary tablespaces on a RAM disk

Laurenz Albe writes: > On Tue, 2020-03-17 at 19:57 +, 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 conf

Re: Temporary tablespaces on a RAM disk

On Tue, 2020-03-17 at 19:57 +, 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

Re: Temporary tablespaces on a RAM disk

Hi Laurenz, >From: Laurenz Albe >Sent: Tuesday, March 17, 2020 20:50 >To: Daniel Westermann (DWE) ; >pgsql-general@lists.postgresql.org >Subject: Re: Temporary tablespaces on a RAM disk >On Tue, 2020-03-17 at 09:49 +, Daniel Westermann (DWE) wrote: >> is

Re: Temporary tablespaces on a RAM disk

>"Daniel Westermann (DWE)" writes: >>> People have asked about this before, so maybe it'd be an idea to make >>> an explicit concept of a temp tablespace that only accepts temp tables, >>> and do whatever is needful to make that robust. But I've not heard of >>> any work towards that. >> That's

Re: Temporary tablespaces on a RAM disk

On Tue, 2020-03-17 at 09:49 +, 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.

Re: Temporary tablespaces on a RAM disk

"Daniel Westermann (DWE)" writes: >> People have asked about this before, so maybe it'd be an idea to make >> an explicit concept of a temp tablespace that only accepts temp tables, >> and do whatever is needful to make that robust. But I've not heard of >> any work towards that. > That's what I

Re: Temporary tablespaces on a RAM disk

Ron writes: > On 3/17/20 12:19 PM, David G. Johnston wrote: >> 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 >>> Warning >>> Placing a tablespace on a temporary file system like a RAM

Re: Temporary tablespaces on a RAM disk

Daniel Westermann 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. >Well, we point our "stats_temp_dir

Re: Temporary tablespaces on a RAM disk

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

Re: Temporary tablespaces on a RAM disk

Ron writes: > On 3/17/20 12:19 PM, David G. Johnston wrote: >> 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 >>> Warning >>> Placing a tablespace on a temporary file system like a RAM

Re: Temporary tablespaces on a RAM disk

On 3/17/20 12:19 PM, David G. Johnston wrote: On Tue, Mar 17, 2020 at 2:49 AM 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 archiv

Re: Temporary tablespaces on a RAM disk

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

RE: Temporary tablespaces on a RAM disk

Daniel Westermann 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. Well, we point our "stats_temp_directory