Re: BUG #13974: temp_file_limit effects vacuum - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #13974: temp_file_limit effects vacuum
Date
Msg-id 26461.1455912265@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #13974: temp_file_limit effects vacuum  (Alvaro Herrera <alvherre@2ndquadrant.com>)
List pgsql-bugs
Alvaro Herrera <alvherre@2ndquadrant.com> writes:
> andreas.papst@univie.ac.at wrote:
>> I'm pretty sure, it works as intended, but maybe it is useful to other
>> postgres users too to have stated in the description of
>> temp_file_limit
>> that this value effects vacuum runs too:
>> vacuumdb: vacuuming of database "test" failed: ERROR:  temporary file
>> size exceeds temp_file_limit (2097152kB)

> This seems like a bug to me.

I don't know what vacuum would be doing that would involve creating
temp files at all.  Seems like we need more information here.

            regards, tom lane

pgsql-bugs by date:

Previous
From: jaime soler gómez
Date:
Subject: Re: BUG #13969: PostgreSQL 9.5.0-1 no longer available from apt.postgresql.org
Next
From: Alvaro Herrera
Date:
Subject: Re: BUG #13970: Vacuum hangs on particular table; cannot be terminated - requires `kill -QUIT pid`