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"
|
| Список | 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 по дате отправления: