Hi,
On 2 April 2012 08:38, Ivan Voras <ivoras(at)freebsd(dot)org> wrote:
> db=> set enable_seqscan to off;
<snip>
>
> This huge cost of 10000000000 which appeared out of nowhere in the
> EXPLAIN output and the seq scan worry me - where did that come from?
It is not possible to disable seq scan completely. The "enable_seqscan
to off" just sets cost of this operation extremely high (10 000 000
000) thus planner is forced look for better plan. In your case planner
wasn't able to find anything better hence
cost=10000000009.55..10000000009.56.
--
Ondrej Ivanic
(ondrej(dot)ivanic(at)gmail(dot)com)