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
Also, it's worth to add autovacuum_enable_temp_tables variable to control
autovacuum behaviour ?
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: oleg(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83
pgsql-hackers by date
|Next:||From: Greg Stark||Date: 2010-04-08 18:30:18|
|Subject: Re: A maze of twisty mailing lists all the same|
|Previous:||From: Frank Jagusch||Date: 2010-04-08 16:59:44|
|Subject: Re: Set LC_COLLATE to de_DE_phoneb|