autovacuum and temp tables support
Oleg Bartunov <oleg@sai.msu.su>
From: Oleg Bartunov <oleg@sai.msu.su>
To: Pgsql Hackers <pgsql-hackers@postgresql.org>
Date: 2010-04-08T18:21:38Z
Lists: pgsql-hackers
Hi there, our client complained about slow query, which involves temporary tables. Analyzing them manually solved the problem. I don't remember arguments against temporary tables support by autovacuum. I'd appreciate any pointers. Also, it's worth to add autovacuum_enable_temp_tables variable to control autovacuum behaviour ? Regards, Oleg _____________________________________________________________ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow University, Russia Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/ phone: +007(495)939-16-83, +007(495)939-23-83