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