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

From Jeroen van Iddekinge
Subject Re: sequence scan on PK
Date
Msg-id 427E5130.7020702@lycos.com
Whole thread Raw
In response to Re: sequence scan on PK  (John A Meinel <john@arbash-meinel.com>)
Responses Re: sequence scan on PK  (Matteo Beccati <php@beccati.com>)
Re: sequence scan on PK  (John A Meinel <john@arbash-meinel.com>)
Re: sequence scan on PK  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
>
> You could tweak with several settings to get it to do an index scan
> earlier, but these would probably break other queries. You don't need to
> tune for 100 rows, morelike 100k or 100M.

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?


Jer.



pgsql-performance by date:

Previous
From: John A Meinel
Date:
Subject: Re: sequence scan on PK
Next
From: Matteo Beccati
Date:
Subject: Re: sequence scan on PK