Re: sequence scan on PK

Поиск
Список
Период
Сортировка
От Jeroen van Iddekinge
Тема Re: sequence scan on PK
Дата
Msg-id 427E736A.4030107@lycos.com
обсуждение исходный текст
Ответ на Re: sequence scan on PK  (Matteo Beccati <php@beccati.com>)
Список pgsql-performance
Matteo Beccati wrote:

> Hi,
>
>> Yes , it was a bit to high (18) so a lowered it. It speeded up some
>> pages for about 5%.
>
>
> 18? The default is 4 if I can remember correctly. I wonder if your db
> has ever seen an index scan ;)
>

I was expermenting how much some setting influence has on the perfomance
of some web application.
So I think i forgot to change the setting back and got some strange
query plans.

Thanks
Jer


В списке pgsql-performance по дате отправления:

Предыдущее
От: "Jim C. Nasby"
Дата:
Сообщение: Re: COPY vs INSERT
Следующее
От: Sam Vilain
Дата:
Сообщение: Re: Whence the Opterons?