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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
