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

Поиск
Список
Период
Сортировка
От Laurenz Albe
Тема Re: Even if I have a lot of free space PgSQL returns "ERROR: could not extend file - No space left on device"
Дата
Msg-id d447afcf8a6aa65c09d3d132a90989548641e141.camel@cybertec.at
обсуждение исходный текст
Ответ на Re: Even if I have a lot of free space PgSQL returns "ERROR: could not extend file - No space left on device"  (bruno da silva <brunogiovs@gmail.com>)
Ответы 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 <conservation.by.geovista.space@gmail.com>)
Список pgsql-novice
Дерево обсуждения 
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 по дате отправления:

Предыдущее
От: bruno da silva
Дата:
Сообщение: Re: Even if I have a lot of free space PgSQL returns "ERROR: could not extend file - No space left on device"
Следующее
От: ivanov17@riseup.net
Дата:
Сообщение: Grant CREATE privilege on all schemas