On 04/10/2011 07:27 PM, Tomas Vondra wrote:
But if you need more details, then I quess the best approach to get it
is to read the sources (search for the cost estimation etc.).
There's a small fully worked out example of this in my book too, where I
duplicate the optimizer's EXPLAIN cost c
There's a quite nice description in the docs:
http://www.postgresql.org/docs/9.0/interactive/row-estimation-examples.html
and a some more details for indexes:
http://www.postgresql.org/docs/9.0/interactive/index-cost-estimation.html
A bit more info about how this is used is available in this pr
