Re: Even if I have a lot of free space PgSQL returns "ERROR: could not extend file - No space left on device"

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(dot)albe(at)cybertec(dot)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
>