Re: sequence scan on PK

Поиск
Список
Период
Сортировка
От Jeroen van Iddekinge
Тема Re: sequence scan on PK
Дата
Msg-id 427E5130.7020702@lycos.com
обсуждение исходный текст
Ответ на Re: sequence scan on PK  (John A Meinel <john@arbash-meinel.com>)
Ответы 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>)
Список 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 по дате отправления:

Предыдущее
От: John A Meinel
Дата:
Сообщение: Re: sequence scan on PK
Следующее
От: Matteo Beccati
Дата:
Сообщение: Re: sequence scan on PK