2009/7/29 A. Kretschmer <andreas(dot)kretschmer(at)schollglas(dot)com>:
> In response to Jake Stride :
>> Hi,
>>
>> I'm trying to optimise a query at the moment, I've added some new
>> indexes to stop seq scans, but I'm now trying to work out if I can
>> stop a join using external sort to speed up the query. I've included
>
> Increase work_mem to force sort in memory.
>
That stops the external storage thanks. I still think I need to
optimise the query though as there are 3 other similar queries which
are unioned together to form a view.
Jake
>
> Andreas