Message-ID: <d447afcf8a6aa65c09d3d132a90989548641e141.camel@cybertec.at>
Subject: Re: Even if I have a lot of free space PgSQL returns "ERROR: could
 not extend file - No space left on device"
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: bruno da silva <brunogiovs@gmail.com>
Cc: Nature Conservation Geovista Space
 <conservation.by.geovista.space@gmail.com>,
 pgsql-novice@lists.postgresql.org
Date: Sat, 09 Sep 2023 04:54:24 +0200
In-Reply-To: 
 <CAB+Nuk87tNEkApQOoSzw1u4vtnKPgksaKLv1t5-w49JkCkotmA@mail.gmail.com>
References: 
	<CA+=_Eg-GYE9BfdQoXkevSv9GkrMbRzsYTDnMoYa_zzQoBQbe6Q@mail.gmail.com>
	 <5520a74bc59f5aed4b29772b04c28d58566013a2.camel@cybertec.at>
	 <CAB+Nuk87tNEkApQOoSzw1u4vtnKPgksaKLv1t5-w49JkCkotmA@mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
User-Agent: Evolution 3.48.4 (3.48.4-1.fc38) 
MIME-Version: 1.0
Archived-At: 
 <https://www.postgresql.org/message-id/d447afcf8a6aa65c09d3d132a90989548641e141.camel%40cybertec.at>
Precedence: bulk

On Fri, 2023-09-08 at 16:01 -0400, bruno da silva wrote:
> Hello. Does temp_file_limt also applies to reindex?

To the extent that REINDEX creates temporary files, yes.
It will limit the size of temporary files created when the
rows are sorted.

It does *not* limit the size of the data files for the new
index.

Yours,
Laurenz Albe