| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| To: | Alban Hertroys <dalroi(at)solfertje(dot)student(dot)utwente(dot)nl> |
| Cc: | Clive Page <cgp(at)star(dot)le(dot)ac(dot)uk>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: How to get RTREE performance from GIST index? |
| Date: | 2009-12-02 20:09:32 |
| Message-ID: | 20091202200932.GF6276@alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Clive Page | 2009-12-02 20:12:26 | Re: How to get RTREE performance from GIST index? |
| Previous Message | River Tarnell | 2009-12-02 19:38:21 | Re: Postgres performance on Veritas VxVM |