Re: Understanding sequential versus index scans. - Mailing list pgsql-general

From Greg Stark
Subject Re: Understanding sequential versus index scans.
Date
Msg-id 407d949e0907200713y6e0a081an3c3908ec1ac0e362@mail.gmail.com
Whole thread Raw
In response to Re: Understanding sequential versus index scans.  (Robert James <srobertjames@gmail.com>)
List pgsql-general
On Mon, Jul 20, 2009 at 2:22 PM, Robert James<srobertjames@gmail.com> wrote:
> BTW, this is interesting, because there are only about 5 or 6 rows max
> returned from both queries - but I guess the planner expects more and hence
> changes the plan to remove duplicates.


If you sent the plans for the various attempts we might be able to
explain what's going on.

--
greg
http://mit.edu/~gsstark/resume.pdf

pgsql-general by date:

Previous
From: Ivan Sergio Borgonovo
Date:
Subject: Re: Documentation Improvement suggestions
Next
From: Greg Stark
Date:
Subject: Re: Understanding INNER JOIN versus IN subquery