Re: why sequential scan is used on indexed column ??? - Mailing list pgsql-general

From Julius Tuskenis
Subject Re: why sequential scan is used on indexed column ???
Date
Msg-id 4854F590.6020501@gmail.com
Whole thread Raw
In response to Re: why sequential scan is used on indexed column ???  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
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

pgsql-general by date:

Previous
From: "D. Dante Lorenso"
Date:
Subject: Need Tool to sync databases with 8.3.1
Next
From: 加入简历库,让好工作找到你
Date:
Subject: 加入简历库,让好工作找到你