Received: from maia.hub.org (maia-2.hub.org [200.46.204.251])
	by mail.postgresql.org (Postfix) with ESMTP id E59E21337BE6
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Sun, 10 Apr 2011 15:23:19 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia,
	port 10024) with ESMTP id 39603-07
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Sun, 10 Apr 2011 18:23:00 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from web38606.mail.mud.yahoo.com (web38606.mail.mud.yahoo.com
	[209.191.125.67])
	by mail.postgresql.org (Postfix) with SMTP id 969121337BCC
	for <pgsql-performance@postgresql.org>;
	Sun, 10 Apr 2011 15:22:59 -0300 (ADT)
Received: (qmail 4708 invoked by uid 60001); 10 Apr 2011 18:22:57 -0000
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024;
	t=1302459777; bh=ceQQIJ055FnG36rfwCsQUTOi+tXASZEiUkxlwq1YoWM=;
	h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type;
	b=fJ+xjAR9TJ9LpcyNIlQPLvmcQhzrIZpOTo+dxRi+eVqCgkD1GkQPp+t+6UtY8/fM9UZNVVhzHt8nnC7aAi5KfKiq8jOQomPevNm4oR/TdCXp7uLGKHv8HLAE8VMwq8AwOPeYE1tw6q6GdodhRHX02p+M4Gn1usbMXKivv7NtG8s=
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type;
	b=fyGKoDhda8ib/oMom3PefnMNx49zNl83PlMFeNH9e20qu22uLnv+jQDFLQZpPr5upd8jLCg/4ZLi2Uw1ZvQZJ0al4r6OluhXOB0EIm+DH/czQuQt7mE6qyOvSVJpt8Uqkidrvig3YYU/P5bjqgSX4hEd/a9MXUoVuTBfFxbZlUs=;
Message-ID: <77760.3733.qm@web38606.mail.mud.yahoo.com>
X-YMail-OSG: l4LwaZUVM1nb2ZfuGPi8XAF2twqCRKnHp_ZI0Dq9AVEONu9
	H.x5ES16RP8InURZNs6RlaJulp7RMJhnjwbkITYwQAre7G5h2TsKIV6jm88p
	u7etVD4gAHxIv.XSBPGMhW6_MpnT51__ndwpK6FwMVrWstSHen.qnUmm35hn
	K96mJWkST6tXvQG8I58f546WBE81XmooyV0JKvIwOwj3j0e76RWJO.bnbFLN
	dEXq3OuqR5sTuKbbes.0EZ9IHSI6EUwCJz67mrc2JN6u5Nva15mMuaCbHHIU
	TQAowNzbk1.hA7gxAQZMb67v3cu9caeHuAsLCdIz2LEqq3JZ5MnrYEHeO92x
	10CzFZwEf_fVkU0fAjQ6cTuWe5P6xyOBH7oT3GWp5CE7OEYutzsHCFXWfv2B
	Z1phx7LE.9G13Dg--
Received: from [41.239.64.42] by web38606.mail.mud.yahoo.com via HTTP;
	Sun, 10 Apr 2011 11:22:57 PDT
X-Mailer: YahooMailRC/559 YahooMailWebService/0.8.109.295617
Date: Sun, 10 Apr 2011 11:22:57 -0700 (PDT)
From: Radhya sahal <rad_cs_2006@yahoo.com>
Subject: optimizer parameters
To: pgsql-performance group <pgsql-performance@postgresql.org>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-1418144876-1302459777=:3733"
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.627 tagged_above=-10 required=5 tests=BAYES_00=-1.9,
	FREEMAIL_ENVFROM_END_DIGIT=1.553, FREEMAIL_FROM=0.001,
	HTML_FONT_FACE_BAD=0.981, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_NONE=-0.0001,
	RFC_ABUSE_POST=0.001, T_RP_MATCHES_RCVD=-0.01
X-Spam-Level: 
X-Archive-Number: 201104/97
X-Sequence-Number: 43159

--0-1418144876-1302459777=:3733
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

Dear ,all =0Ai would to ask you=A0about how postgresql optimizer parameters=
=A0:-=0A1- random page cost =0A2- cpu tuple cost3- cpu operator cost4- cpu =
index tuple cost5- effective cache =0Asize=0Aplay as parameters in cost est=
imator equation=A0=0Ai imagine that cost function is the same as=0Af(x,y,z,=
....)=3Dax+by......=0Acost(cpu tuple cost,cpu operator cost,....)=0Acan any=
 one help me=A0to know the equation that cost estimator used it..=0AMy rega=
rd =0ARadhya,,,,
--0-1418144876-1302459777=:3733
Content-Type: text/html; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

<html><head><style type=3D"text/css"><!-- DIV {margin:0px;} --></style></he=
ad><body><div style=3D"font-family:times new roman, new york, times, serif;=
font-size:14pt;color:#ff00ff;"><DIV><FONT color=3D#2d2d2d size=3D4>Dear ,al=
l </FONT></DIV>=0A<DIV><FONT color=3D#2d2d2d size=3D4>i would to ask you&nb=
sp;about how postgresql optimizer parameters&nbsp;:-</FONT></DIV>=0A<DIV><F=
ONT size=3D4><FONT color=3D#2d2d2d>1- <FONT face=3DCMTT9><FONT face=3DCMTT9=
>random page cost </FONT></FONT></FONT></FONT></DIV>=0A<DIV><FONT face=3DCM=
TT9><FONT face=3DCMTT9>=0A<P><FONT color=3D#2d2d2d size=3D4>2- cpu tuple co=
st</FONT></P><FONT face=3DCMTT9><FONT face=3DCMTT9>=0A<P><FONT color=3D#2d2=
d2d size=3D4>3- cpu operator cost</FONT></P><FONT face=3DCMTT9><FONT face=
=3DCMTT9>=0A<P><FONT color=3D#2d2d2d size=3D4>4- cpu index tuple cost</FONT=
></P><FONT face=3DCMTT9><FONT color=3D#2d2d2d size=3D4 face=3DCMTT9>=0A<P>5=
- effective cache size</P>=0A<P>play as parameters in cost estimator equati=
on&nbsp;</P>=0A<P>i imagine that cost function is the same as</P>=0A<P>f(x,=
y,z,....)=3Dax+by......</P>=0A<P>cost(cpu tuple cost,cpu operator cost,....=
)</P>=0A<P>can any one help me&nbsp;to know the equation that cost estimato=
r used it..</P>=0A<P>My regard </P>=0A<P>Radhya,,,,</P>=0A<P>&nbsp;</P></FO=
NT></FONT></FONT></FONT></FONT></FONT></FONT></FONT></DIV></div></body></ht=
ml>
--0-1418144876-1302459777=:3733--