Re: How to get RTREE performance from GIST index?

Alban Hertroys wrote:

> "In the default PostgreSQL configuration, The Autovacuum Daemon takes
> care of automatic analyzing of tables when they are first loaded with
> data, and as they change throughout regular operation. When autovacuum
> is disabled, it is a good idea to run ANALYZE periodically, or just
> after making major changes in the contents of a table."
>
> That last line isn't explicit about temporary tables, but the reason
> for running ANALYZE in both cases is the same.

Actually, autovacuum doesn't process temp tables at all because it
cannot get to them; they might live solely in the creating process'
private memory area.

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