MIME-Version: 1.0
References: 
 <CA+=_Eg-GYE9BfdQoXkevSv9GkrMbRzsYTDnMoYa_zzQoBQbe6Q@mail.gmail.com>
 <5520a74bc59f5aed4b29772b04c28d58566013a2.camel@cybertec.at>
 <CAB+Nuk87tNEkApQOoSzw1u4vtnKPgksaKLv1t5-w49JkCkotmA@mail.gmail.com>
 <d447afcf8a6aa65c09d3d132a90989548641e141.camel@cybertec.at>
In-Reply-To: <d447afcf8a6aa65c09d3d132a90989548641e141.camel@cybertec.at>
From: Nature Conservation Geovista Space
 <conservation.by.geovista.space@gmail.com>
Date: Tue, 12 Sep 2023 13:12:37 +0100
Message-ID: 
 <CA+=_Eg8px00BgKanc7D8eh2yDY62HmgqOzvAN7-=FspBR-fjNQ@mail.gmail.com>
Subject: Re: Even if I have a lot of free space PgSQL returns "ERROR: could
 not extend file - No space left on device"
To: pgsql-novice@lists.postgresql.org
Content-Type: multipart/alternative; boundary="0000000000007e3c5b0605285cd3"
Archived-At: 
 <https://www.postgresql.org/message-id/CA%2B%3D_Eg8px00BgKanc7D8eh2yDY62HmgqOzvAN7-%3DFspBR-fjNQ%40mail.gmail.com>
Precedence: bulk

--0000000000007e3c5b0605285cd3
Content-Type: text/plain; charset="UTF-8"

Hi Laurenz,

Thanks a lot for your kind support.

1 - At the moment my *postgresql.conf *is by default with no limit
*#temp_file_limit
= -1*
Maybe I just have to uncomment it so that this rule really applies. Let's
see this evening if your suggestion fix it.

2 - Do you think it could come from another param not set up correctly?

3 - Can I try to watch out the log or size of the temporary table created
after my query failed so that I can investigate what happened?

Cheers,

Vincent

On Sat, 9 Sept 2023 at 03:54, Laurenz Albe <laurenz.albe@cybertec.at> wrote:

> 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
>

--0000000000007e3c5b0605285cd3
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Hi Laurenz,=C2=A0<div><br></div><div>Thanks a lot for your=
 kind support.</div><div><br></div><div>1 - At the moment my=C2=A0<i>postgr=
esql.conf=C2=A0</i>is by default with no limit=C2=A0 =C2=A0<b>#temp_file_li=
mit =3D -1</b><div>Maybe I just have to uncomment it so that this rule real=
ly applies. Let&#39;s see this evening if your suggestion fix it.<br></div>=
<div><br></div><div>2 - Do you think it could come from another param not s=
et up correctly?</div><div><br></div><div>3 - Can I try to watch out the lo=
g or size of the temporary table created after my query failed so that=C2=
=A0I can investigate what happened?</div></div><div><br></div><div>Cheers,<=
/div><div><br></div><div>Vincent</div></div><br><div class=3D"gmail_quote">=
<div dir=3D"ltr" class=3D"gmail_attr">On Sat, 9 Sept 2023 at 03:54, Laurenz=
 Albe &lt;<a href=3D"mailto:laurenz.albe@cybertec.at">laurenz.albe@cybertec=
.at</a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"marg=
in:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1e=
x">On Fri, 2023-09-08 at 16:01 -0400, bruno da silva wrote:<br>
&gt; Hello. Does temp_file_limt also applies to reindex?<br>
<br>
To the extent that REINDEX creates temporary files, yes.<br>
It will limit the size of temporary files created when the<br>
rows are sorted.<br>
<br>
It does *not* limit the size of the data files for the new<br>
index.<br>
<br>
Yours,<br>
Laurenz Albe<br>
</blockquote></div>

--0000000000007e3c5b0605285cd3--