On Tue, Mar 21, 2006 at 03:08:07PM -0300, Fernando Lujan wrote: > I'm trying to figure out when Sequence Scan is better than Index Scan. I > just want to know this because I disabled the sequence scan in > postgresql and receive a better result. :) That is a very broad question, and you're introducing somewhat of a false choice since you're talking about joins (a join can be solved by more methods than just "sequential scan" or not). Could you please paste the exact query you're using, with EXPLAIN ANALYZE for both the case with and without sequential scans? /* Steinar */ -- Homepage: http://www.sesse.net/
