public inbox for [email protected]
help / color / mirror / Atom feedFrom: Laurenz Albe <[email protected]>
To: Nature Conservation Geovista Space <[email protected]>
To: [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, 08 Sep 2023 19:51:15 +0200
Message-ID: <[email protected]> (raw)
In-Reply-To: <CA+=_Eg-GYE9BfdQoXkevSv9GkrMbRzsYTDnMoYa_zzQoBQbe6Q@mail.gmail.com>
References: <CA+=_Eg-GYE9BfdQoXkevSv9GkrMbRzsYTDnMoYa_zzQoBQbe6Q@mail.gmail.com>
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]
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: <[email protected]>
* 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