On Thu, Jun 18, 2009 at 6:16 PM, Brian Cox
<brian.cox@ca.com> wrote:
Grzegorz Jakiewicz [
gryzman@gmail.com] 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