Re: How to get RTREE performance from GIST index? - Mailing list pgsql-general

From Clive Page
Subject Re: How to get RTREE performance from GIST index?
Date
Msg-id 4B16CA2A.3070900@star.le.ac.uk
Whole thread Raw
In response to Re: How to get RTREE performance from GIST index?  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: How to get RTREE performance from GIST index?  (Alban Hertroys <dalroi@solfertje.student.utwente.nl>)
List pgsql-general
> 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.
>

Does that mean that, in between creating a temporary table and actually
using it in a complicate query, it is desirable to run an ANALYZE
command on it?

I haven't been doing that, because I didn't know.

Regards

--
Clive Page

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: How to get RTREE performance from GIST index?
Next
From: Tech 2010
Date:
Subject: Re: vacuumdb: vacuuming of database "xy" failed: PANIC: corrupted item pointer: 19227