Re: why sequential scan is used on indexed column ???

From: Julius Tuskenis <julius(dot)tuskenis(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Michael Fuhr <mike(at)fuhr(dot)org>, Andreas Kretschmer <akretschmer(at)spamfence(dot)net>, pgsql-general(at)postgresql(dot)org
Subject: Re: why sequential scan is used on indexed column ???
Date: 2008-06-15 10:57:20
Message-ID: 4854F590.6020501@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Kellerer 2008-06-15 14:36:03 Re: Need Tool to sync databases with 8.3.1
Previous Message Julius Tuskenis 2008-06-15 10:43:02 Re: why sequential scan is used on indexed column ???