Re: autovacuum and temp tables support - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: autovacuum and temp tables support
Date
Msg-id 20100408185351.GH4126@alvh.no-ip.org
Whole thread Raw
In response to autovacuum and temp tables support  (Oleg Bartunov <oleg@sai.msu.su>)
Responses Re: autovacuum and temp tables support  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
Oleg Bartunov wrote:

> 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.

Autovacuum can't process temp tables; they could reside in a backend's
private temp buffers (local memory, not shared).

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.


pgsql-hackers by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: A maze of twisty mailing lists all the same
Next
From: "Kevin Grittner"
Date:
Subject: Re: A maze of twisty mailing lists all the same