Re: reducing random_page_cost from 4 to 2 to force index scan

From: Claudio Freire <klaussfreire(at)gmail(dot)com>
To: Merlin Moncure <mmoncure(at)gmail(dot)com>
Cc: Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>, Sok Ann Yap <sokann(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: reducing random_page_cost from 4 to 2 to force index scan
Date: 2011-04-27 07:23:32
Message-ID: BANLkTi=_UqUNumJgrc+kV6MbOmtw+grzCQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Wed, Apr 27, 2011 at 9:22 AM, Claudio Freire <klaussfreire(at)gmail(dot)com> wrote:
> The problem there, I think, is that the planner is doing a full join,
> instead of a semi-join.

Or, rather, computing cost as if it was a full join. I'm not sure why.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Kevin Grittner 2011-04-27 12:40:58 Re: reducing random_page_cost from 4 to 2 to force index scan
Previous Message Claudio Freire 2011-04-27 07:22:31 Re: reducing random_page_cost from 4 to 2 to force index scan