| From: | Alban Hertroys <dalroi(at)solfertje(dot)student(dot)utwente(dot)nl> |
|---|---|
| To: | Clive Page <cgp(at)star(dot)le(dot)ac(dot)uk> |
| Cc: | Alvaro Herrera <alvherre(at)commandprompt(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: How to get RTREE performance from GIST index? |
| Date: | 2009-12-02 23:21:23 |
| Message-ID: | 089733BC-04BF-41B9-9540-7AD049F87021@solfertje.student.utwente.nl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 2 Dec 2009, at 21:12, Clive Page wrote:
>> 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.
Only if you created an index on it. If you didn't it doesn't matter as in that case you always get a sequential scan, unless I'm mistaken.
Alban Hertroys
--
Screwing up is the best way to attach something to the ceiling.
!DSPAM:737,4b16f67511731227681557!
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rikard Bosnjakovic | 2009-12-02 23:24:27 | Re: Auto Vacuum Daemon |
| Previous Message | John R Pierce | 2009-12-02 23:09:09 | Re: How to auto-increment? |