Re: autovacuum and temp tables support

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Alvaro Herrera" <alvherre(at)commandprompt(dot)com>, "Robert Haas" <robertmhaas(at)gmail(dot)com>
Cc: "Pgsql Hackers" <pgsql-hackers(at)postgresql(dot)org>, "Oleg Bartunov" <oleg(at)sai(dot)msu(dot)su>
Subject: Re: autovacuum and temp tables support
Date: 2010-04-08 19:13:01
Message-ID: 4BBDE46D02000025000305F7@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Robert Haas <robertmhaas(at)gmail(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Jaime Casanova 2010-04-08 19:16:20 Re: A maze of twisty mailing lists all the same
Previous Message Joshua D. Drake 2010-04-08 19:09:50 Re: A maze of twisty mailing lists all the same