Hi, On 2 April 2012 08:38, Ivan Voras <ivoras@xxxxxxxxxxx> 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.ivanic@xxxxxxxxx) -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
