From: Chad Wagner <chad.wagner@gmail.com>
To: Rob Schall <rschall@callone.net>
Cc: Stephan Szabo <sszabo@megazone.bigpanda.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Identical Queries
Date: Thu, 1 Mar 2007 16:09:17 -0500
Message-ID: <81961ff50703011309v43c0974eie31172e36f8460cd@mail.gmail.com> (raw)
In-Reply-To: <45E73DA5.40808@callone.net>
References: <45E6F49D.3010707@callone.net>
<20070301112948.R45862@megazone.bigpanda.com>
<45E73DA5.40808@callone.net>
On 3/1/07, Rob Schall <rschall@callone.net> wrote:
>
> There are 4 entries (wanted to make the playing field level for this
> test). There are 2 with true for istf and 2 with false.
>
Then the difference here has to do with using orignum vs destnum as the join
criteria. There must be more intersections for orignum than destnum, or
your statistics are so far out of whack. It appears to be estimating 5M vs
500K for a result set, and naturally it chose a different plan.
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: chad.wagner@gmail.com, rschall@callone.net, sszabo@megazone.bigpanda.com
Subject: Re: Identical Queries
In-Reply-To: <81961ff50703011309v43c0974eie31172e36f8460cd@mail.gmail.com>
* 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