Postgres Pro
Downloads
Home   >   mailing lists

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

From Laurenz Albe
Subject Re: Even if I have a lot of free space PgSQL returns "ERROR: could not extend file - No space left on device"
Date
Msg-id d447afcf8a6aa65c09d3d132a90989548641e141.camel@cybertec.at
Whole thread Raw
In response to 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>)
Responses 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>)
List pgsql-novice
Tree view 
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 by date:

Previous
From: bruno da silva
Date:
Subject: Re: Even if I have a lot of free space PgSQL returns "ERROR: could not extend file - No space left on device"
Next
From: ivanov17@riseup.net
Date:
Subject: Grant CREATE privilege on all schemas