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

Поиск
Список
Период
Сортировка
От Nature Conservation Geovista Space
Тема Re: Even if I have a lot of free space PgSQL returns "ERROR: could not extend file - No space left on device"
Дата
Msg-id CA+=_Eg8px00BgKanc7D8eh2yDY62HmgqOzvAN7-=FspBR-fjNQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Even if I have a lot of free space PgSQL returns "ERROR: could not extend file - No space left on device"  (Laurenz Albe <laurenz.albe@cybertec.at>)
Ответы Re: Even if I have a lot of free space PgSQL returns "ERROR: could not extend file - No space left on device"  (Laurenz Albe <laurenz.albe@cybertec.at>)
Список pgsql-novice
Дерево обсуждения
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.albe@cybertec.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

В списке pgsql-novice по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Grant CREATE privilege on all schemas
Следующее
От: Laurenz Albe
Дата:
Сообщение: Re: Even if I have a lot of free space PgSQL returns "ERROR: could not extend file - No space left on device"