Sunday, June 15, 2008

Re: [GENERAL] why sequential scan is used on indexed column ???

Hello, Tom.

> So I think the OP's
> problem is purely a statistical one, or maybe he's in a situation where
> he should reduce random_page_cost.)
>
What could be done solving that "statistical problem"? :) Current value
for random_page_cost is 4. What value would you suggest?

Julius Tuskenis

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

No comments: