Re: How to get RTREE performance from GIST index? - Mailing list 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
theplanner'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