Postgres Pro
Downloads
Home   >   mailing lists

Re: Strange cost computation? - Mailing list pgsql-hackers

From Stephan Szabo
Subject Re: Strange cost computation?
Date
Msg-id 20021030075807.L31345-100000@megazone23.bigpanda.com
Whole thread Raw
In response to Strange cost computation?  (ives.landrieu@ua.ac.be (Ives Landrieu))
Responses Re: Strange cost computation?  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List pgsql-hackers
Tree view 
On 29 Oct 2002, Ives Landrieu wrote:

> Hi,
>
> Can anybody explain the following results when using EXPLAIN,
> one time with enable_seqscan=on and one time with enable_seqscan=off.
> What I don't understand is that the nodes created are the same
> (index scan, seq scan), but the costs differ.

Enable seq scan actually just sets a large cost disbenefit to seq scans.
Is alias96.STATUS indexed?

pgsql-hackers by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: float output precision questions
Next
From: Stephan Szabo
Date:
Subject: Re: Strange cost computation?