This is a multi-part message in MIME format.
------=_NextPart_000_0029_01CA87CB.F253F5E0
Content-Type: text/plain;
charset="koi8-r"
Content-Transfer-Encoding: quoted-printable
Our 8.3.7 production environment is run on Linux operating systems. We =
do,
however
Have our developers who keep a local copy of the database on their =
windows
XP machines.
One such developer has asked my help in configuring postgresql.conf to
optimize his performance.
The 8.3 documentation is very informative about setting Linux SYS 5
parameters and
giving insight to postgres memory consumption parms. I can't seem to =
find a
lot of guidelines
for Windows performance.
The developer has 3 GB of ram and 130 GB hard drive. Any insight,
guidelines,
Or any reference I can be pointed to would be most appreciated.
Thank you,
Mark Steben=81Database Administrator
[at] utoRevenueR-"Join the Revenue-tion"
95 Ashley Ave., West Springfield, Ma
413-243-4800 x1512 (Phone) =81 413.732-1824 (Fax)
[at] utoRevenue is a registered trademark and a division of Dominion =
Enterprises
------=_NextPart_000_0029_01CA87CB.F253F5E0
Content-Type: text/html;
charset="koi8-r"
Content-Transfer-Encoding: quoted-printable
<html xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:st1=3D"urn:schemas-microsoft-com:office:smarttags" =
xmlns=3D"http://www.w3.org/TR/REC-html40"
xmlns:ns0=3D"urn:schemas-microsoft-com:office:smarttags">
<head>
<meta http-equiv=3DContent-Type content=3D"text/html; charset=3Dkoi8-r">
<meta name=3DGenerator content=3D"Microsoft Word 11 (filtered medium)">
<o:SmartTagType =
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
name=3D"Street"/>
<o:SmartTagType =
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
name=3D"City"/>
<o:SmartTagType =
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
name=3D"address"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
[at] font-face
{font-family:"Franklin Gothic Medium";
panose-1:2 11 6 3 2 1 2 2 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:Arial;
color:windowtext;}
[at] page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=3DEN-US link=3Dblue vlink=3Dpurple>
<div class=3DSection1>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>Our 8.3.7 production environment is run on Linux =
operating
systems.=9A We do, however<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>Have our developers who keep a local copy of the =
database on
their windows XP machines.<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>One such developer has asked my help in configuring
postgresql.conf to optimize his =
performance.<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>The 8.3 documentation is very informative about =
setting
Linux SYS 5 parameters and<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>giving insight to postgres memory consumption =
parms.=9A I can’t
seem to find a lot of guidelines <o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>for Windows performance.<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>The developer has 3 GB of ram and 130 GB hard =
drive.=9A Any
insight, guidelines,<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>Or any reference I can be pointed to would be most
appreciated.<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>Thank you,<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>=9A <o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal =
style=3D'mso-margin-top-alt:auto;mso-margin-bottom-alt:auto' ><span
class=3Dspelle><font size=3D2 color=3Dblack face=3D"Franklin Gothic =
Medium"><span
style=3D'font-size:10.0pt;font-family:"Franklin Gothic =
Medium";color:black'>Mark
Steben</span></font></span><span class=3Dspelle><font size=3D2 =
color=3Dred
face=3D"Franklin Gothic Medium"><span =
style=3D'font-size:10.0pt;font-family:"Franklin Gothic Medium";
color:red'>=81</span></font></span><span class=3Dspelle><font size=3D2 =
color=3Dblack
face=3D"Franklin Gothic Medium"><span =
style=3D'font-size:10.0pt;font-family:"Franklin Gothic Medium";
color:black'>Database Administrator</span></font></span><o:p></o:p></p>
<p class=3DMsoNormal><font size=3D5 color=3D"#3366ff" face=3D"Times New =
Roman"><span
style=3D'font-size:16.0pt;color:#3366FF'> [at] </span></font><font size=3D4
color=3D"#3366ff"><span =
style=3D'font-size:14.0pt;color:#3366FF'>utoRevenue</span></font><sup><fo=
nt
color=3D"#3366ff"><span =
style=3D'color:#3366FF'>®</span></font></sup><i><font
size=3D4 color=3D"#3366ff"><span =
style=3D'font-size:14.0pt;color:#3366FF;font-style:
italic'>-</span></font></i><i><font size=3D1 color=3D"#3366ff"><span
style=3D'font-size:7.5pt;color:#3366FF;font-style:italic'>"Join the
Revenue-tion"</span></font></i><i><font size=3D2 color=3Dred
face=3D"Franklin Gothic Medium"><span =
style=3D'font-size:10.0pt;font-family:"Franklin Gothic Medium";
color:red;font-style:italic'><br>
</span></font></i><font size=3D2 face=3D"Franklin Gothic Medium"><span
style=3D'font-size:10.0pt;font-family:"Franklin Gothic =
Medium"'><u7:STREET u4:st=3D"on"><u7:ADDRESS u4:st=3D"on"><u7:ADDRESS =
u5:st=3D"on"><u7:STREET u5:st=3D"on"><u8:address u9:st=3D"on"><u8:Street =
u9:st=3D"on"><ns0:address
w:insAuthor=3D"Mark Steben" w:insDate=3D"2009-12-28T14:27:00Z"
w:endInsAuthor=3D"Mark Steben" =
w:endInsDate=3D"2009-12-28T14:27:00Z"><ns0:Street
w:insAuthor=3D"Mark Steben" w:insDate=3D"2009-12-28T14:27:00Z"
w:endInsAuthor=3D"Mark Steben" =
w:endInsDate=3D"2009-12-28T14:27:00Z"><st1:address
w:st=3D"on"><st1:Street w:st=3D"on"><font color=3Dgray><span =
style=3D'color:gray'>95
Ashley Ave., West</span></font></st1:Street><font =
color=3Dgray><span
style=3D'color:gray'> <st1:City =
w:st=3D"on">Springfield</st1:City></span></font></st1:address><font
color=3Dgray><span style=3D'color:gray'>, =
Ma</u8:Street></u8:address></u7:STREET></u7:ADDRESS></u7:ADDRESS></u7:STR=
EET></span></font></ns0:Street></ns0:address><font
color=3Dgray><span style=3D'color:gray'><br>
413-243-4800 x1512 (Phone) </span></font><font color=3Dred><span
style=3D'color:red'>=81 </span></font><font color=3Dgray><span =
style=3D'color:
gray'>413.732-1824 (Fax<span class=3Dgrame>)</span><br>
</span></font></span></font><font size=3D1 color=3Dgray
face=3D"Franklin Gothic Medium"><span =
style=3D'font-size:7.5pt;font-family:"Franklin Gothic Medium";
color:gray'> [at] utoRevenue is a registered trademark and a division of =
Dominion
Enterprises</span></font><o:p></o:p></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'><o:p> </o:p></span></font></p>
</div>
</body>
</html>
------=_NextPart_000_0029_01CA87CB.F253F5E0--
