pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Steinar H. Gunderson <sgunderson@bigfoot.com>
To: pgsql-performance@postgresql.org
Subject: Re: Odd sorting behaviour
Date: Tue, 20 Jul 2004 19:21:00 +0200
Message-ID: <20040720172100.GA22262@uio.no> (raw)
In-Reply-To: <200407201006.08649.josh@agliodbs.com>
References: <20040708101913.GA15871@uio.no>
	<20040715120854.GA31259@uio.no>
	<20040720115116.GB19633@uio.no>
	<200407201006.08649.josh@agliodbs.com>

On Tue, Jul 20, 2004 at 10:06:08AM -0700, Josh Berkus wrote:
> Actually, quick question -- have you tried setting enable_mergjoin=false to 
> see the plan the system comes up with?  Is it in fact faster?

It is significantly faster -- 1200ms vs. 1900ms (on 7.4, at least). Some of
the merge joins are changed to nested loop joins, though, which probably
reduces the overall performance, so I guess there's more to gain if I can get
it to convert only that merge join to a hash join. The sum and multiplication
parts still take 400ms or so, though (is this normal? :-) ), so I guess
there's a lower limit :-)

I could of course post the updated query plan if anybody is interested; let
me know. (The data is still available if anybody needs it as well, of
course.)

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



view thread (15+ messages)  latest in thread

Message-ID: <20040720172100.GA22262@uio.no>
Permalink:  ../20040720172100.GA22262@uio.no/
Also on:    postgresql.org/message-id/20040720172100.GA22262@uio.no

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: sgunderson@bigfoot.com
  Subject: Re: Odd sorting behaviour
  In-Reply-To: <20040720172100.GA22262@uio.no>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox