Re: Strange logic for partial index proving

Tom Lane wrote:
> Richard Huxton <dev@archonet.com> writes:
> 
>>laser wrote:
>>>Aggregate (cost=100009638.60..100009638.60 rows=1 width=0) (actual
>>>time=1567.317..1567.318 rows=1 loops=1)
>>>-> Seq Scan on partial_idx_t (cost=100000000.00..100008327.88
>>>rows=524288 width=0) (actual time=0.046..906.747 rows=524288 loops=1)
>>>Total runtime: 1567.401 ms
> 
> 
>>I'd say your configuration settings are a long way from accurate.
> 
> 
> Actually, I'd say these estimates are pretty good.  Ignoring the
> 100000000 penalty from "set enable_seqscan off", we have:

<sigh> of course the 100 million is from seqscan=off, that's what he was 
demonstrating. Sometimes I wonder why I get out of bed in the mornings :-/

--   Richard Huxton  Archonet Ltd