Re: sequence scan on PK

From: Matteo Beccati <php(at)beccati(dot)com>
To: Jeroen van Iddekinge <iddekingej(at)lycos(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: sequence scan on PK
Date: 2005-05-08 16:18:46
Message-ID: 427E3BE6.5040702@beccati.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi,

> Thanks for respone.
> The index scan was a little bit faster for id=1 and faster for id=99.
>
> Which settings shoud I change for this? cpu_index_tuple_cost ,
> cpu_operator_cost, cpu_tuple_cost?

You should lower random_page_cost to make the planner choose an index
scan vs sequential scan.

Best regards
--
Matteo Beccati
http://phpadsnew.com/
http://phppgads.com/

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message John A Meinel 2005-05-08 16:24:36 Re: sequence scan on PK
Previous Message Jeroen van Iddekinge 2005-05-08 14:59:13 sequence scan on PK