Re: autovacuum and temp tables support

Kevin Grittner <kevin.grittner@wicourts.gov>

From: "Kevin Grittner" <Kevin.Grittner@wicourts.gov>

To: "Alvaro Herrera" <alvherre@commandprompt.com>, "Robert Haas" <robertmhaas@gmail.com>

Cc: "Pgsql Hackers" <pgsql-hackers@postgresql.org>, "Oleg Bartunov" <oleg@sai.msu.su>

Date: 2010-04-08T19:13:01Z

Lists: pgsql-hackers

Robert Haas <robertmhaas@gmail.com> wrote:
> On Thu, Apr 8, 2010 at 2:53 PM, Alvaro Herrera
 
>> Autovacuum can't process temp tables; they could reside in a
>> backend's private temp buffers (local memory, not shared).
> 
> it would be nice if the first attempt to SELECT against a table
> with no statistics would trigger an automatic ANALYZE by the
> backend on which the query was executed.
 
+1 as an RFE
 
-Kevin