On Thu, Jun 18, 2009 at 6:16 PM, Brian Cox <[email protected]> wrote: > Grzegorz Jakiewicz [[email protected]] wrote: > >> this might be quite bogus question, just a hit - but what is your >> work_mem set to ? >> Guys, isn't postgresql giving hudge cost, when it can't sort in memory ? >> > work_mem = 64MB > try increasing it please, to say 256MB
8.4 in explain analyze actually informs you whether sorting was done on disc or in memory, but you probably don't run stuff on cutting edge ;) -- GJ
