Re: sequence scan on PK - Mailing list pgsql-performance

From Matteo Beccati
Subject Re: sequence scan on PK
Date
Msg-id 427E3BE6.5040702@beccati.com
Whole thread Raw
In response to Re: sequence scan on PK  (Jeroen van Iddekinge <iddekingej@lycos.com>)
Responses Re: sequence scan on PK  (Jeroen van Iddekinge <iddekingej@lycos.com>)
List 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/

pgsql-performance by date:

Previous
From: Jeroen van Iddekinge
Date:
Subject: Re: sequence scan on PK
Next
From: John A Meinel
Date:
Subject: Re: sequence scan on PK