Re: index vs. seq scan choice?

In article <415(dot)1181255628(at)sss(dot)pgh(dot)pa(dot)us>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
% "George Pavlov" <gpavlov(at)mynewplace(dot)com> writes:
% >> From: Joshua D. Drake [mailto:jd(at)commandprompt(dot)com]
% >> In those rare cases wouldn't it make more sense to just set
% >> enable_seqscan to off; run query; set enable_seqscan to on;
%
% > 1. these cases are not that rare (to me);
%
% It strikes me that you probably need to adjust the planner cost
% parameters to reflect reality on your system. Usually dropping
% random_page_cost is the way to bias the thing more in favor of
% index scans.

Also, increasing effective_cache_size.
(And increasing statistics...)
--

Patrick TJ McPhee
North York Canada
ptjm(at)interlog(dot)com