Re: Odd sorting behaviour - Mailing list pgsql-performance

From Steinar H. Gunderson
Subject Re: Odd sorting behaviour
Date
Msg-id 20040720115116.GB19633@uio.no
Whole thread Raw
In response to Re: Odd sorting behaviour  ("Steinar H. Gunderson" <sgunderson@bigfoot.com>)
Responses Re: Odd sorting behaviour  (Josh Berkus <josh@agliodbs.com>)
Re: Odd sorting behaviour  (Josh Berkus <josh@agliodbs.com>)
List pgsql-performance
On Thu, Jul 15, 2004 at 02:08:54PM +0200, Steinar H. Gunderson wrote:
> sort_mem is already 16384, which I thought would be plenty -- I tried
> increasing it to 65536 which made exactly zero difference. :-)

I've tried some further tweaking, but I'm still unable to force it into doing
a hash join -- any ideas how I can find out why it chooses a merge join?

/* Steinar */
--
Homepage: http://www.sesse.net/

pgsql-performance by date:

Previous
From: "abhousehunt"
Date:
Subject: Re: Working on huge RAM based datasets
Next
From: Grega Bremec
Date:
Subject: Re: NAS, SAN or any alternate solution ?