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
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
