| From: | Emre Hasegeli <emre(at)hasegeli(dot)com> |
|---|---|
| To: | David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> |
| Cc: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: BRIN cost estimate |
| Date: | 2017-04-05 05:34:29 |
| Message-ID: | CAE2gYzy0NC3m_ufU1edGmNFgOYu5Tuf4pY2+is3YkM+gSdwP7g@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rushabh Lathia | 2017-04-05 05:41:50 | Re: Adding support for Default partition in partitioning |
| Previous Message | Amit Langote | 2017-04-05 05:29:08 | Re: Adding support for Default partition in partitioning |