On 18-1-2007 23:11 Tom Lane wrote:
Increase work_mem? It's not taking the hash because it thinks it won't fit in memory ...
When I increase it to 128MB in the session (arbitrarily selected relatively large value) it indeed has the other plan.
Best regards, Arjen ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings