Re: BRIN cost estimate

Поиск
Список
Период
Сортировка
От Emre Hasegeli
Тема Re: BRIN cost estimate
Дата
Msg-id CAE2gYzy0NC3m_ufU1edGmNFgOYu5Tuf4pY2+is3YkM+gSdwP7g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: BRIN cost estimate  (David Rowley <david.rowley@2ndquadrant.com>)
Ответы Re: BRIN cost estimate
Список pgsql-hackers
Дерево обсуждения

Interested to hear comments on this.

I don't have chance to test it right now, but I am sure it would be an improvement over what we have right now.  There is no single correct equation with so many unknowns we have.

>   *indexTotalCost += (numTuples * *indexSelectivity) * (cpu_index_tuple_cost + qual_op_cost);

Have you preserved this line intentionally?  This would make BRIN index scan cost even higher, but the primary property of BRIN is to be cheap to scan. Shouldn't bitmap heap scan node take into account of checking the tuples in its cost?

p.p1 {margin: 0.0px 0.0px 0.0px 0.0px} span.s1 {font-family: 'Helvetica'; font-weight: normal; font-style: normal; font-size: 12.00pt} span.Apple-tab-span {white-space:pre}

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

Предыдущее
От: Amit Langote
Дата:
Сообщение: Re: Adding support for Default partition in partitioning
Следующее
От: Rushabh Lathia
Дата:
Сообщение: Re: Adding support for Default partition in partitioning