MIME-Version: 1.0
References: 
 <CA+=_Eg-GYE9BfdQoXkevSv9GkrMbRzsYTDnMoYa_zzQoBQbe6Q@mail.gmail.com>
 <5520a74bc59f5aed4b29772b04c28d58566013a2.camel@cybertec.at>
In-Reply-To: <5520a74bc59f5aed4b29772b04c28d58566013a2.camel@cybertec.at>
From: bruno da silva <brunogiovs@gmail.com>
Date: Fri, 8 Sep 2023 16:01:03 -0400
Message-ID: 
 <CAB+Nuk87tNEkApQOoSzw1u4vtnKPgksaKLv1t5-w49JkCkotmA@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: Laurenz Albe <laurenz.albe@cybertec.at>
Cc: Nature Conservation Geovista Space
 <conservation.by.geovista.space@gmail.com>,
	pgsql-novice@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000617de10604de70a3"
Archived-At: 
 <https://www.postgresql.org/message-id/CAB%2BNuk87tNEkApQOoSzw1u4vtnKPgksaKLv1t5-w49JkCkotmA%40mail.gmail.com>
Precedence: bulk

--000000000000617de10604de70a3
Content-Type: text/plain; charset="UTF-8"

Hello. Does temp_file_limt also applies to reindex?

Thanks

On Fri, Sept 8, 2023, 3:54 p.m. Laurenz Albe <laurenz.albe@cybertec.at>
wrote:

> On Fri, 2023-09-08 at 12:22 +0100, Nature Conservation Geovista Space
> wrote:
> > After hours running a query to Subdivide, I get this Postgres error
> > >
> > > 2023-09-08 02:11:23.745 BST [328594] postgres@database ERROR:  could
> not extend file "base/16388/7985375.1020": No space left on device
> > > 2023-09-08 02:11:23.745 BST [328594] postgres@database HINT:  Check
> free disk space.
> > >
> > > 2023-09-08 02:11:23.745 BST [328594] postgres@database  STATEMENT:
> CREATE TABLE _gaul_administrative_subdivided100 AS (
> > >                 SELECT *, st_subdivide(geom,100) AS geom_subdivided100
> > >                         FROM gaul_administrative
> > >         );
> >
> > It seems that it is not a problem of space. [df shows there is space
> everywhere]
>
> "After running a query for hours" makes it appear like you run out of disk
> space with
> temporary files.  These only exist during the lifetime of the query, so
> they are gone again after
> the statement has failed.
>
> Set "temp_file_limit" to avoid that kind of problem.
>
> Yours,
> Laurenz Albe
>
>
>

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

<div dir=3D"auto">Hello. Does temp_file_limt also applies to reindex?<div d=
ir=3D"auto"><br></div><div dir=3D"auto">Thanks</div></div><br><div class=3D=
"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Fri, Sept 8, 2023, 3=
:54 p.m. Laurenz Albe &lt;<a href=3D"mailto:laurenz.albe@cybertec.at">laure=
nz.albe@cybertec.at</a>&gt; wrote:<br></div><blockquote class=3D"gmail_quot=
e" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">=
On Fri, 2023-09-08 at 12:22 +0100, Nature Conservation Geovista Space wrote=
:<br>
&gt; After hours running a query to Subdivide, I get this Postgres error<br=
>
&gt; &gt; =C2=A0<br>
&gt; &gt; 2023-09-08 02:11:23.745 BST [328594] postgres@database ERROR:=C2=
=A0 could not extend file &quot;base/16388/7985375.1020&quot;: No space lef=
t on device<br>
&gt; &gt; 2023-09-08 02:11:23.745 BST [328594] postgres@database HINT:=C2=
=A0 Check free disk space.<br>
&gt; &gt; =C2=A0<br>
&gt; &gt; 2023-09-08 02:11:23.745 BST [328594] postgres@database=C2=A0 STAT=
EMENT:=C2=A0 CREATE TABLE _gaul_administrative_subdivided100 AS (<br>
&gt; &gt; =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0 SELECT *, st_subdivide(geom,100) AS geom_subdiv=
ided100 <br>
&gt; &gt; =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
 FROM gaul_administrative <br>
&gt; &gt; =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 );<br>
&gt; <br>
&gt; It seems that it is not a problem of space. [df shows there is space e=
verywhere]<br>
<br>
&quot;After running a query for hours&quot; makes it appear like you run ou=
t of disk space with<br>
temporary files.=C2=A0 These only exist during the lifetime of the query, s=
o they are gone again after<br>
the statement has failed.<br>
<br>
Set &quot;temp_file_limit&quot; to avoid that kind of problem.<br>
<br>
Yours,<br>
Laurenz Albe<br>
<br>
<br>
</blockquote></div>

--000000000000617de10604de70a3--