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