Thread: BUG #13974: temp_file_limit effects vacuum

The following bug has been logged on the website:

Bug reference:      13974
Logged by:          Andreas Papst
Email address:      andreas.papst@univie.ac.at
PostgreSQL version: 9.4.6
Operating system:   Debian
Description:

Hey,

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)

Just my 2 ct.

Thank you
Andreas

Link: http://www.postgresql.org/docs/9.4/static/runtime-config-resource.html

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.

--
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

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