From: Radhya sahal <rad_cs_2006@yahoo.com>
To: Nathan Boley <npboley@gmail.com>
To: pgsql-performance group <pgsql-performance@postgresql.org>
Subject: Re: how explain works to Mr Nathan Boley
Date: Mon, 11 Apr 2011 16:22:27 -0700 (PDT)
Message-ID: <52482.84679.qm@web38603.mail.mud.yahoo.com> (raw)
In-Reply-To: <BANLkTikjvRxdZTPjNEPW_uNv=Y55r+tPDg@mail.gmail.com>
References: <64088.55807.qm@web38604.mail.mud.yahoo.com>
<BANLkTikjvRxdZTPjNEPW_uNv=Y55r+tPDg@mail.gmail.com>
Thanks Mr Nathan Boley ,
i want these equations to solve thsese equtions of parameters and total time in
order to get each paramter formula
i need these formula in my experiments is very important to know the rate for
each parameter in total cost for plan.
Best
Radhya..
________________________________
From: Nathan Boley <npboley@gmail.com>
To: Radhya sahal <rad_cs_2006@yahoo.com>
Cc: pgsql-performance group <pgsql-performance@postgresql.org>
Sent: Mon, April 11, 2011 4:09:07 PM
Subject: Re: [PERFORM] how explain works
> how explian works as math equations to estimate cost with constatn query
> parameters
> such as cpu_tuple cost ,random page cost ...etc
> i want maths expression in order to know how these parameters will effect
> in cost ???
The expressions are complicated, and they are certainly not linear as
you seem to think from your previous post.
> please any one can help me ??
What do you need this for? If your goal is to optimize a real
application, then you should just vary the cost parameters and measure
the resulting change in query times. If your interests are academic,
there were some excellent suggestions for places to start in response
to your previous post.
Best,
Nathan
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: rad_cs_2006@yahoo.com, npboley@gmail.com
Subject: Re: how explain works to Mr Nathan Boley
In-Reply-To: <52482.84679.qm@web38603.mail.mud.yahoo.com>
* 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