Skip site navigation (1) Skip section navigation (2)

Re: Odd sorting behaviour

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: "Steinar H(dot) Gunderson" <sgunderson(at)bigfoot(dot)com>,pgsql-performance(at)postgresql(dot)org
Subject: Re: Odd sorting behaviour
Date: 2004-07-20 17:06:08
Message-ID: 200407201006.08649.josh@agliodbs.com (view raw or flat)
Thread:
Lists: 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

In response to

Responses

pgsql-performance by date

Next:From: Steinar H. GundersonDate: 2004-07-20 17:21:00
Subject: Re: Odd sorting behaviour
Previous:From: Josh BerkusDate: 2004-07-20 17:02:49
Subject: Re: Odd sorting behaviour

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group