public inbox for [email protected]
help / color / mirror / Atom feedFrom: 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: Tue, 12 Sep 2023 13:12:37 +0100
Message-ID: <CA+=_Eg8px00BgKanc7D8eh2yDY62HmgqOzvAN7-=FspBR-fjNQ@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <CA+=_Eg-GYE9BfdQoXkevSv9GkrMbRzsYTDnMoYa_zzQoBQbe6Q@mail.gmail.com>
<[email protected]>
<CAB+Nuk87tNEkApQOoSzw1u4vtnKPgksaKLv1t5-w49JkCkotmA@mail.gmail.com>
<[email protected]>
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 <[email protected]> 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
>
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]
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: <CA+=_Eg8px00BgKanc7D8eh2yDY62HmgqOzvAN7-=FspBR-fjNQ@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