Re: Index scan cost calculation

From: Glyn Astill <glynastill(at)yahoo(dot)co(dot)uk>
To: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
Cc: Pgsql-performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Index scan cost calculation
Date: 2015-12-01 11:22:12
Message-ID: 1810845895.22017405.1448968932390.JavaMail.yahoo@mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

>
>Clauses that can't be used in an "indexable" way are excluded from the
>index selectivity, but not from the total query selectivity.
>
>> Or is it just likely that the selection of the new index is just by chance?
>
>Bingo.
>

Got it, thanks! Very much appreciated.

Glyn

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Jim Nasby 2015-12-02 22:32:43 Re: Index scan cost calculation
Previous Message Jeff Janes 2015-11-30 23:03:23 Re: Index scan cost calculation