Home > mailing lists

Re: Fwd: temp_file_limit? - Mailing list pgsql-performance

From	Ranier Vilela
Subject	Re: Fwd: temp_file_limit?
Date	December 19, 2022 15:15:14
Msg-id	CAEudQApMfeL1=+YooZcDyvgNYAuo21sRZkO0OaXQ7LaTs84L8A@mail.gmail.com Whole thread Raw
In response to	Re: Fwd: temp_file_limit? (Frits Jalvingh <jal@etc.to>)
Responses	Re: Fwd: temp_file_limit?
List	pgsql-performance

Em seg., 19 de dez. de 2022 às 06:47, Frits Jalvingh <jal@etc.to> escreveu:

The test is running on Ubuntu 22.04.1, x86_64, the disk is an NVMe 2TB WD850X with ext4 as a file system.

It's probably not a production environment.
Any chance of adding another 2TB NVMe, just for the temp files?

To see if Postgres can finish the queries and provide more information?
What exactly is the version of Postgres (14.???) are you using it?

regards,

Ranier Vilela

From: Frits Jalvingh
Date: 19 December 2022, 12:47:34
Subject: Re: Fwd: temp_file_limit?

From: Frits Jalvingh
Date: 19 December 2022, 17:45:25
Subject: Re: Fwd: temp_file_limit?