Re: An unwanted seqscan - Mailing list pgsql-performance

From Tom Lane
Subject Re: An unwanted seqscan
Date
Msg-id 20031.1171443234@sss.pgh.pa.us
Whole thread Raw
In response to An unwanted seqscan  (Brian Herlihy <btherl@yahoo.com.au>)
List pgsql-performance
Brian Herlihy <btherl@yahoo.com.au> writes:
> I am having trouble understanding why a seqscan is chosen for this query.

As far as anyone can see from this output, the planner's decisions are
correct: it prefers the plans with the smaller estimated cost.  If you
want us to take an interest, provide some more context --- EXPLAIN
ANALYZE output for starters.

            regards, tom lane

pgsql-performance by date:

Previous
From: Brian Herlihy
Date:
Subject: An unwanted seqscan
Next
From: "Claus Guttesen"
Date:
Subject: Re: quad or dual core Intel CPUs