Re: Odd sorting behaviour - Mailing list pgsql-performance

From Josh Berkus
Subject Re: Odd sorting behaviour
Date
Msg-id 200407201006.08649.josh@agliodbs.com
Whole thread Raw
In response to Re: Odd sorting behaviour  ("Steinar H. Gunderson" <sgunderson@bigfoot.com>)
Responses Re: Odd sorting behaviour  ("Steinar H. Gunderson" <sgunderson@bigfoot.com>)
List pgsql-performance
Steinar,

> 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?

Actually, quick question -- have you tried setting enable_mergjoin=false to
see the plan the system comes up with?  Is it in fact faster?

--
Josh Berkus
Aglio Database Solutions
San Francisco

pgsql-performance by date:

Previous
From: Josh Berkus
Date:
Subject: Re: Odd sorting behaviour
Next
From: "Steinar H. Gunderson"
Date:
Subject: Re: Odd sorting behaviour