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
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
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 oftemp_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
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/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
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs