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