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

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: bruno da silva <brunogiovs(at)gmail(dot)com>
Cc: Nature Conservation Geovista Space <conservation(dot)by(dot)geovista(dot)space(at)gmail(dot)com>, pgsql-novice(at)lists(dot)postgresql(dot)org
Subject: Re: Even if I have a lot of free space PgSQL returns "ERROR: could not extend file - No space left on device"
Date: 2023-09-09 02:54:24
Message-ID: d447afcf8a6aa65c09d3d132a90989548641e141.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message ivanov17 2023-09-12 01:05:30 Grant CREATE privilege on all schemas
Previous Message bruno da silva 2023-09-08 20:01:03 Re: Even if I have a lot of free space PgSQL returns "ERROR: could not extend file - No space left on device"