Re: Puzzling table scan in a CTE

Поиск
Список
Период
Сортировка
Искать
От
Kevin Grittner
Тема
Re: Puzzling table scan in a CTE
Дата
Msg-id
1385148245.49487.YahooMailNeo@web162904.mail.bf1.yahoo.com
Ответ на
Puzzling table scan in a CTE ()
Список
Дерево обсуждения
Puzzling table scan in a CTE <slapo@centrum.sk>
Re: Puzzling table scan in a CTE Kevin Grittner <kgrittn@ymail.com>
Re: [GENERAL] Puzzling table scan in a CTE <slapo@centrum.sk>
Re: Puzzling table scan in a CTE Elliot <yields.falsehood@gmail.com>
Re: [GENERAL] Puzzling table scan in a CTE <slapo@centrum.sk>
Re: Puzzling table scan in a CTE Elliot <yields.falsehood@gmail.com>
Re: [GENERAL] Puzzling table scan in a CTE <slapo@centrum.sk> 
"slapo@centrum.sk"  wrote:

> I have a recursive CTE where a table scan occurs, even though
> there doesn't seem to be a good reason for it.

Do you have effective_cache_size set to 50% to 75% of machine RAM? 
Do you have cpu_tuple_cost set to between 0.03 and 0.05?  If not,
do changes to these settings help?

--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
В списке pgsql-general по дате отправления
Предыдущее
От: Tomas Vondra
Дата:
Следующее
От: Kevin Grittner
Дата:
FAQ