From: Tomas Vondra <tv@fuzzy.cz>
To: pgsql-performance@postgresql.org
Subject: Re: optimizer parameters
Date: Mon, 11 Apr 2011 01:27:58 +0200
Message-ID: <4DA23CFE.7020109@fuzzy.cz> (raw)
In-Reply-To: <77760.3733.qm@web38606.mail.mud.yahoo.com>
References: <77760.3733.qm@web38606.mail.mud.yahoo.com>
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 presentation:
http://momjian.us/main/writings/pgsql/internalpics.pdf
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.).
regards
Tomas
Dne 10.4.2011 20:22, Radhya sahal napsal(a):
> Dear ,all
> i would to ask you about how postgresql optimizer parameters :-
> 1- random page cost
>
> 2- cpu tuple cost
>
> 3- cpu operator cost
>
> 4- cpu index tuple cost
>
> 5- 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,,,,
>
>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: tv@fuzzy.cz
Subject: Re: optimizer parameters
In-Reply-To: <4DA23CFE.7020109@fuzzy.cz>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox