Re: Strange logic for partial index proving - Mailing list pgsql-hackers

From Richard Huxton
Subject Re: Strange logic for partial index proving
Date
Msg-id 42BACC65.6010102@archonet.com
Whole thread Raw
In response to Re: Strange logic for partial index proving  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: HEAD initdb failing on OSX
Next
From: Andrew Dunstan
Date:
Subject: regression failure