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

Re: 7k records into Sort node, 4.5m out?

From: Christophe Pettus <xof(at)thebuild(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: 7k records into Sort node, 4.5m out?
Date: 2012-08-15 19:13:19
Message-ID: 623F2FF3-B79D-419A-929A-41C707DD5EA3@thebuild.com (view raw or flat)
Thread:
Lists: pgsql-performance
On Aug 13, 2012, at 7:11 PM, Tom Lane wrote:
> The whole thing looks a bit weird to me --- why did it not use a
> nestloop join with inner indexscan on charlie?  With 7000 rows on the
> other side, the estimated cost for that shouldn't have been more than
> about 30000 ...

Here's the same query with set enable_megejoin = off.  All of the other query tuning parameters are default.

	http://explain.depesz.com/s/dqO

--
-- Christophe Pettus
   xof(at)thebuild(dot)com



In response to

Responses

pgsql-performance by date

Next:From: Tom LaneDate: 2012-08-15 20:51:12
Subject: Re: 7k records into Sort node, 4.5m out?
Previous:From: Doug HunleyDate: 2012-08-15 13:43:07
Subject: Re: cluster on conditional index?

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