Re: sequential scan unduly favored over text search gin index

Поиск
Список
Период
Сортировка
От Sushant Sinha
Тема Re: sequential scan unduly favored over text search gin index
Дата
Msg-id 1308623134.1747.1.camel@dragflick
обсуждение исходный текст
Ответ на Re: sequential scan unduly favored over text search gin index  (Tomas Vondra <tv@fuzzy.cz>)
Ответы Re: sequential scan unduly favored over text search gin index  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-performance
>
> I agree the estimates are damn precise in this case (actually the
> estimates are exact). The problem is the planner thinks the seq scan is
> about 30% cheaper than the bitmap index scan.
>
> I guess you could poke the planner towards the bitmap scan by lowering
> the random_page_cost (the default value is 4, I'd say lowering it to 2
> should do the trick).

The numbers that I gave was after setting random_page_cost = 1.0 After
this I don't know what to do.

-Sushant.


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

Предыдущее
От: Jon Nelson
Дата:
Сообщение: Re: bad plan: 8.4.8, hashagg, work_mem=1MB.
Следующее
От: Mario Guerrero
Дата:
Сообщение: Cross Table (Pivot)