Re: Unexpected sequence scan

["Kevin Grittner" <Kevin.Grittner@xxxxxxxxxxxx>]

Dan Fairs <dan.fairs@xxxxxxxxx> wrote:
 
> I have a query which is running slowly, and the query plan shows
> an unexpected sequence scan where I'd have expected the planner to
> use an index. 
 
Looking at the actual row counts compared to run time, it appears
that the active portion of your data set is heavily cached.  In such
an environment, I would add these lines to postgresql.conf, to
better model costs:
 
seq_page_cost = 0.1
random_page_cost = 0.1  # or maybe slightly higher
cpu_tuple_cost = 0.03
 
-Kevin

-- 
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance