public inbox for [email protected]  

help / color / mirror / Atom feed

From: bruno da silva <[email protected]>
To: Laurenz Albe <[email protected]>
Cc: Nature Conservation Geovista Space <[email protected]>
Cc: [email protected]
Subject: Re: Even if I have a lot of free space PgSQL returns "ERROR: could not extend file - No space left on device"
Date: Fri, 8 Sep 2023 16:01:03 -0400
Message-ID: <CAB+Nuk87tNEkApQOoSzw1u4vtnKPgksaKLv1t5-w49JkCkotmA@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <CA+=_Eg-GYE9BfdQoXkevSv9GkrMbRzsYTDnMoYa_zzQoBQbe6Q@mail.gmail.com>
	<[email protected]>

Hello. Does temp_file_limt also applies to reindex?

Thanks

On Fri, Sept 8, 2023, 3:54 p.m. Laurenz Albe <[email protected]>
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
>
>
>

view thread (6+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected], [email protected]
  Subject: Re: Even if I have a lot of free space PgSQL returns "ERROR: could not extend file - No space left on device"
  In-Reply-To: <CAB+Nuk87tNEkApQOoSzw1u4vtnKPgksaKLv1t5-w49JkCkotmA@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox