Skip site navigation (1) Skip section navigation (2)

autovacuum and temp tables support

From: Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
To: Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: autovacuum and temp tables support
Date: 2010-04-08 18:21:38
Message-ID: Pine.LNX.4.64.1004082216260.8023@sn.sai.msu.ru (view raw or flat)
Thread:
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(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83

Responses

pgsql-hackers by date

Next:From: Greg StarkDate: 2010-04-08 18:30:18
Subject: Re: A maze of twisty mailing lists all the same
Previous:From: Frank JaguschDate: 2010-04-08 16:59:44
Subject: Re: Set LC_COLLATE to de_DE_phoneb

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group