pgbench_1800_300.htm
text/html
Filename: pgbench_1800_300.htm
Type: text/html
Part: 3
<html xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=gb2312">
<meta name=ProgId content=Excel.Sheet>
<meta name=Generator content="Microsoft Excel 12">
<link rel=File-List href="pgbench_1800_300_files/filelist.xml">
<style id="pgbench_11009_Styles">
<!--table
{mso-displayed-decimal-separator:"\.";
mso-displayed-thousand-separator:"\,";}
.xl1511009
{padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignore:padding;
color:windowtext;
font-size:10.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Arial, sans-serif;
mso-font-charset:0;
mso-number-format:General;
text-align:general;
vertical-align:bottom;
mso-background-source:auto;
mso-pattern:auto;
white-space:nowrap;}
.xl6311009
{padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignore:padding;
color:windowtext;
font-size:10.0pt;
font-weight:700;
font-style:normal;
text-decoration:none;
font-family:Arial, sans-serif;
mso-font-charset:0;
mso-number-format:General;
text-align:general;
vertical-align:bottom;
border:.5pt solid windowtext;
mso-background-source:auto;
mso-pattern:auto;
white-space:nowrap;}
.xl6411009
{padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignore:padding;
color:windowtext;
font-size:10.0pt;
font-weight:700;
font-style:normal;
text-decoration:none;
font-family:Arial, sans-serif;
mso-font-charset:0;
mso-number-format:General;
text-align:center;
vertical-align:bottom;
border:.5pt solid windowtext;
mso-background-source:auto;
mso-pattern:auto;
white-space:nowrap;}
.xl6511009
{padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignore:padding;
color:windowtext;
font-size:10.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Arial, sans-serif;
mso-font-charset:0;
mso-number-format:General;
text-align:general;
vertical-align:bottom;
border:.5pt solid windowtext;
mso-background-source:auto;
mso-pattern:auto;
white-space:nowrap;}
.xl6611009
{padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignore:padding;
color:windowtext;
font-size:10.0pt;
font-weight:700;
font-style:normal;
text-decoration:none;
font-family:Arial, sans-serif;
mso-font-charset:0;
mso-number-format:General;
text-align:general;
vertical-align:bottom;
mso-background-source:auto;
mso-pattern:auto;
white-space:nowrap;}
.xl6711009
{padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignore:padding;
color:windowtext;
font-size:10.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Arial, sans-serif;
mso-font-charset:0;
mso-number-format:General;
text-align:general;
vertical-align:bottom;
border:.5pt solid windowtext;
background:#95B3D7;
mso-pattern:black none;
white-space:nowrap;}
.xl6811009
{padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignore:padding;
color:windowtext;
font-size:10.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Arial, sans-serif;
mso-font-charset:0;
mso-number-format:General;
text-align:right;
vertical-align:bottom;
border:.5pt solid windowtext;
mso-background-source:auto;
mso-pattern:auto;
white-space:nowrap;}
.xl6911009
{padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignore:padding;
color:windowtext;
font-size:10.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Arial, sans-serif;
mso-font-charset:0;
mso-number-format:General;
text-align:right;
vertical-align:bottom;
mso-background-source:auto;
mso-pattern:auto;
white-space:nowrap;}
.xl7011009
{padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignore:padding;
color:windowtext;
font-size:10.0pt;
font-weight:700;
font-style:normal;
text-decoration:none;
font-family:Arial, sans-serif;
mso-font-charset:0;
mso-number-format:General;
text-align:center;
vertical-align:middle;
border-top:.5pt solid windowtext;
border-right:.5pt solid windowtext;
border-bottom:none;
border-left:.5pt solid windowtext;
mso-background-source:auto;
mso-pattern:auto;
white-space:nowrap;}
.xl7111009
{padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignore:padding;
color:windowtext;
font-size:10.0pt;
font-weight:700;
font-style:normal;
text-decoration:none;
font-family:Arial, sans-serif;
mso-font-charset:0;
mso-number-format:General;
text-align:center;
vertical-align:middle;
border-top:none;
border-right:.5pt solid windowtext;
border-bottom:.5pt solid windowtext;
border-left:.5pt solid windowtext;
mso-background-source:auto;
mso-pattern:auto;
white-space:nowrap;}
.xl7211009
{padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignore:padding;
color:windowtext;
font-size:10.0pt;
font-weight:700;
font-style:normal;
text-decoration:none;
font-family:Arial, sans-serif;
mso-font-charset:0;
mso-number-format:General;
text-align:center;
vertical-align:bottom;
border-top:.5pt solid windowtext;
border-right:none;
border-bottom:.5pt solid windowtext;
border-left:.5pt solid windowtext;
mso-background-source:auto;
mso-pattern:auto;
white-space:nowrap;}
.xl7311009
{padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignore:padding;
color:windowtext;
font-size:10.0pt;
font-weight:700;
font-style:normal;
text-decoration:none;
font-family:Arial, sans-serif;
mso-font-charset:0;
mso-number-format:General;
text-align:center;
vertical-align:bottom;
border-top:.5pt solid windowtext;
border-right:.5pt solid windowtext;
border-bottom:.5pt solid windowtext;
border-left:none;
mso-background-source:auto;
mso-pattern:auto;
white-space:nowrap;}
-->
</style>
</head>
<body>
<!--[if !excel]> <![endif]-->
<!--The following information was generated by Microsoft Office Excel's Publish
as Web Page wizard.-->
<!--If the same item is republished from Excel, all information between the DIV
tags will be replaced.-->
<!----------------------------->
<!--START OF OUTPUT FROM EXCEL PUBLISH AS WEB PAGE WIZARD -->
<!----------------------------->
<div id="pgbench_11009" align=center x:publishsource="Excel">
<table border=0 cellpadding=0 cellspacing=0 width=540 style='border-collapse:
collapse;table-layout:fixed;width:405pt'>
<col width=123 style='mso-width-source:userset;mso-width-alt:4498;width:92pt'>
<col width=97 style='mso-width-source:userset;mso-width-alt:3547;width:73pt'>
<col width=64 span=5 style='width:48pt'>
<tr height=17 style='height:12.75pt'>
<td height=17 class=xl6611009 width=123 style='height:12.75pt;width:92pt'>Machine
details</td>
<td class=xl1511009 width=97 style='width:73pt'></td>
<td class=xl1511009 width=64 style='width:48pt'></td>
<td class=xl1511009 width=64 style='width:48pt'></td>
<td class=xl1511009 width=64 style='width:48pt'></td>
<td class=xl1511009 width=64 style='width:48pt'></td>
<td class=xl1511009 width=64 style='width:48pt'></td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 class=xl6511009 style='height:12.75pt'>CPU</td>
<td class=xl6811009 style='border-left:none'>8 core</td>
<td class=xl1511009></td>
<td class=xl1511009></td>
<td class=xl1511009></td>
<td class=xl1511009></td>
<td class=xl1511009></td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 class=xl6511009 style='height:12.75pt;border-top:none'>OS</td>
<td class=xl6811009 style='border-top:none;border-left:none'>suse linux 10.3</td>
<td class=xl1511009></td>
<td class=xl1511009></td>
<td class=xl1511009></td>
<td class=xl1511009></td>
<td class=xl1511009></td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 class=xl6511009 style='height:12.75pt;border-top:none'>RAM</td>
<td class=xl6811009 style='border-top:none;border-left:none'>24GB</td>
<td class=xl1511009></td>
<td class=xl1511009></td>
<td class=xl1511009></td>
<td class=xl1511009></td>
<td class=xl1511009></td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 class=xl1511009 style='height:12.75pt'></td>
<td class=xl1511009></td>
<td class=xl1511009></td>
<td class=xl1511009></td>
<td class=xl1511009></td>
<td class=xl1511009></td>
<td class=xl1511009></td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 class=xl6611009 colspan=2 style='height:12.75pt'>Server
Configuration</td>
<td class=xl1511009></td>
<td class=xl1511009></td>
<td class=xl1511009></td>
<td class=xl1511009></td>
<td class=xl1511009></td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 class=xl6511009 style='height:12.75pt'>sync commit</td>
<td class=xl6811009 style='border-left:none'>off</td>
<td class=xl1511009></td>
<td class=xl1511009></td>
<td class=xl1511009></td>
<td class=xl1511009></td>
<td class=xl1511009></td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 class=xl6511009 style='height:12.75pt;border-top:none'>shared
buffers</td>
<td class=xl6811009 style='border-top:none;border-left:none'>2GB</td>
<td class=xl1511009></td>
<td class=xl1511009></td>
<td class=xl1511009></td>
<td class=xl1511009></td>
<td class=xl1511009></td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 class=xl6511009 style='height:12.75pt;border-top:none'>ckpt
segments</td>
<td class=xl6811009 style='border-top:none;border-left:none'>256</td>
<td class=xl1511009></td>
<td class=xl1511009></td>
<td class=xl1511009></td>
<td class=xl1511009></td>
<td class=xl1511009></td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 class=xl6511009 style='height:12.75pt;border-top:none'>ckpt
interval</td>
<td class=xl6811009 style='border-top:none;border-left:none'>15Min</td>
<td class=xl1511009></td>
<td class=xl1511009></td>
<td class=xl1511009></td>
<td class=xl1511009></td>
<td class=xl1511009></td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 class=xl6611009 style='height:12.75pt'></td>
<td class=xl6911009></td>
<td class=xl1511009></td>
<td class=xl1511009></td>
<td class=xl1511009></td>
<td class=xl1511009></td>
<td class=xl1511009></td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 class=xl6611009 colspan=2 style='height:12.75pt'>Pgbench tcp_b
benchmark suite</td>
<td class=xl1511009></td>
<td class=xl1511009></td>
<td class=xl1511009></td>
<td class=xl1511009></td>
<td class=xl1511009></td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 class=xl6511009 style='height:12.75pt'>threads</td>
<td class=xl6511009 align=right style='border-left:none'>8</td>
<td class=xl1511009></td>
<td class=xl1511009></td>
<td class=xl1511009></td>
<td class=xl1511009></td>
<td class=xl1511009></td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 class=xl6511009 style='height:12.75pt;border-top:none'>clients</td>
<td class=xl6511009 align=right style='border-top:none;border-left:none'>16</td>
<td class=xl1511009></td>
<td class=xl1511009></td>
<td class=xl1511009></td>
<td class=xl1511009></td>
<td class=xl1511009></td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 class=xl6511009 style='height:12.75pt;border-top:none'>scale</td>
<td class=xl6511009 align=right style='border-top:none;border-left:none'>10</td>
<td class=xl1511009></td>
<td class=xl1511009></td>
<td class=xl1511009></td>
<td class=xl1511009></td>
<td class=xl1511009></td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 class=xl6511009 style='height:12.75pt;border-top:none'>fill
factor</td>
<td class=xl6511009 align=right style='border-top:none;border-left:none'>100</td>
<td class=xl1511009></td>
<td class=xl1511009></td>
<td class=xl1511009></td>
<td class=xl1511009></td>
<td class=xl1511009></td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 class=xl6511009 style='height:12.75pt;border-top:none'>only
update</td>
<td class=xl6811009 style='border-top:none;border-left:none'>yes</td>
<td class=xl1511009></td>
<td class=xl1511009></td>
<td class=xl1511009></td>
<td class=xl1511009></td>
<td class=xl1511009></td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 class=xl6511009 style='height:12.75pt;border-top:none'>one
record size</td>
<td class=xl6811009 style='border-top:none;border-left:none'>1800 bytes</td>
<td class=xl1511009></td>
<td class=xl1511009></td>
<td class=xl1511009></td>
<td class=xl1511009></td>
<td class=xl1511009></td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 class=xl6511009 style='height:12.75pt;border-top:none'>update
column size</td>
<td class=xl6811009 style='border-top:none;border-left:none'>300 bytes</td>
<td class=xl1511009></td>
<td class=xl1511009></td>
<td class=xl1511009></td>
<td class=xl1511009></td>
<td class=xl1511009></td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 class=xl1511009 style='height:12.75pt'></td>
<td class=xl1511009></td>
<td class=xl1511009></td>
<td class=xl1511009></td>
<td class=xl1511009></td>
<td class=xl1511009></td>
<td class=xl1511009></td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 class=xl1511009 style='height:12.75pt'></td>
<td class=xl1511009></td>
<td class=xl1511009></td>
<td class=xl1511009></td>
<td class=xl1511009></td>
<td class=xl1511009></td>
<td class=xl1511009></td>
</tr>
<tr height=17 style='height:12.75pt'>
<td rowspan=2 height=34 class=xl7011009 style='border-bottom:.5pt solid black;
height:25.5pt'>pgbench<span style='mso-spacerun:yes'> </span></td>
<td colspan=2 class=xl7211009 style='border-right:.5pt solid black;
border-left:none'>old code</td>
<td colspan=2 class=xl7211009 style='border-right:.5pt solid black;
border-left:none'>Modified code</td>
<td colspan=2 class=xl7211009 style='border-right:.5pt solid black;
border-left:none'>Difference(%)</td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 class=xl6411009 style='height:12.75pt;border-top:none;
border-left:none'>TPS</td>
<td class=xl6411009 style='border-top:none;border-left:none'>Total</td>
<td class=xl6411009 style='border-top:none;border-left:none'>TPS</td>
<td class=xl6411009 style='border-top:none;border-left:none'>Total</td>
<td class=xl6411009 style='border-top:none;border-left:none'>TPS</td>
<td class=xl6411009 style='border-top:none;border-left:none'>Total</td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 class=xl6311009 style='height:12.75pt;border-top:none'>Run1</td>
<td class=xl6511009 align=right style='border-top:none;border-left:none'>1751</td>
<td class=xl6511009 align=right style='border-top:none;border-left:none'>1053397</td>
<td class=xl6511009 align=right style='border-top:none;border-left:none'>3134</td>
<td class=xl6511009 align=right style='border-top:none;border-left:none'>1884769</td>
<td class=xl6511009 align=right style='border-top:none;border-left:none'>78.98344</td>
<td class=xl6511009 align=right style='border-top:none;border-left:none'>78.92295</td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 class=xl6311009 style='height:12.75pt;border-top:none'>Run2</td>
<td class=xl6511009 align=right style='border-top:none;border-left:none'>1699</td>
<td class=xl6511009 align=right style='border-top:none;border-left:none'>1020779</td>
<td class=xl6511009 align=right style='border-top:none;border-left:none'>3191</td>
<td class=xl6511009 align=right style='border-top:none;border-left:none'>1916461</td>
<td class=xl6511009 align=right style='border-top:none;border-left:none'>87.81636</td>
<td class=xl6511009 align=right style='border-top:none;border-left:none'>87.74495</td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 class=xl6311009 style='height:12.75pt;border-top:none'>Run3</td>
<td class=xl6511009 align=right style='border-top:none;border-left:none'>1786</td>
<td class=xl6511009 align=right style='border-top:none;border-left:none'>1074239</td>
<td class=xl6511009 align=right style='border-top:none;border-left:none'>3266</td>
<td class=xl6511009 align=right style='border-top:none;border-left:none'>1963313</td>
<td class=xl6511009 align=right style='border-top:none;border-left:none'>82.86674</td>
<td class=xl6511009 align=right style='border-top:none;border-left:none'>82.76315</td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 class=xl6311009 style='height:12.75pt;border-top:none'>Avg</td>
<td class=xl6511009 align=right style='border-top:none;border-left:none'>1745.333333</td>
<td class=xl6511009 align=right style='border-top:none;border-left:none'>1049472</td>
<td class=xl6511009 align=right style='border-top:none;border-left:none'>3197</td>
<td class=xl6511009 align=right style='border-top:none;border-left:none'>1921514</td>
<td class=xl6711009 align=right style='border-top:none;border-left:none'>83.17418</td>
<td class=xl6711009 align=right style='border-top:none;border-left:none'>83.09349</td>
</tr>
<![if supportMisalignedColumns]>
<tr height=0 style='display:none'>
<td width=123 style='width:92pt'></td>
<td width=97 style='width:73pt'></td>
<td width=64 style='width:48pt'></td>
<td width=64 style='width:48pt'></td>
<td width=64 style='width:48pt'></td>
<td width=64 style='width:48pt'></td>
<td width=64 style='width:48pt'></td>
</tr>
<![endif]>
</table>
</div>
<!----------------------------->
<!--END OF OUTPUT FROM EXCEL PUBLISH AS WEB PAGE WIZARD-->
<!----------------------------->
</body>
</html>