optimizer parameters

From: Radhya sahal <rad_cs_2006(at)yahoo(dot)com>
To: pgsql-performance group <pgsql-performance(at)postgresql(dot)org>
Subject: optimizer parameters
Date: 2011-04-10 18:22:57
Message-ID: 77760.3733.qm@web38606.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Dear ,all
i would to ask you about how postgresql optimizer parameters :-
1- random page cost
2- cpu tuple cost3- cpu operator cost4- cpu index tuple cost5- effective cache
size
play as parameters in cost estimator equation 
i imagine that cost function is the same as
f(x,y,z,....)=ax+by......
cost(cpu tuple cost,cpu operator cost,....)
can any one help me to know the equation that cost estimator used it..
My regard
Radhya,,,,

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tomas Vondra 2011-04-10 23:27:58 Re: optimizer parameters
Previous Message Chris Ruprecht 2011-04-09 17:23:51 Re: Multiple index builds on same table - in one sweep?