Re: How to get RTREE performance from GIST index?

From: Clive Page <cgp(at)star(dot)le(dot)ac(dot)uk>
To: Alban Hertroys <dalroi(at)solfertje(dot)student(dot)utwente(dot)nl>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: How to get RTREE performance from GIST index?
Date: 2009-11-22 12:19:03
Message-ID: 4B092C37.1090908@star.le.ac.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 22/11/2009 12:09, Alban Hertroys wrote:
> If you expect indexes to work efficiently on temporary tables you should analyse them after filling them to update the planner's statistics on their contents. If you don't you get the default query plan that's often not efficient.

Alban

Thanks - I didn't know that. I'll try removing the TEMPORARY tag.

Is it documented somewhere that I should have seen?

Regards

--
Clive Page

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Clive Page 2009-11-22 12:24:50 Re: How to get RTREE performance from GIST index?
Previous Message Martijn van Oosterhout 2009-11-22 12:15:09 Re: How to get RTREE performance from GIST index?