Horton
Menu

pgbench_org.htm

text/html

Download
Filename: pgbench_org.htm
Type: text/html
Part: 2
Message: [WIP] Performance Improvement by reducing WAL for Update Operation 
<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_org_files/filelist.xml">
<style id="pgbench_26196_Styles">
<!--table
	{mso-displayed-decimal-separator:"\.";
	mso-displayed-thousand-separator:"\,";}
.xl1526196
	{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;}
.xl6326196
	{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;}
.xl6426196
	{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;}
.xl6526196
	{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;}
.xl6626196
	{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;}
.xl6726196
	{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;}
.xl6826196
	{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;}
.xl6926196
	{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-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;}
.xl7026196
	{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;}
.xl7126196
	{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;}
.xl7226196
	{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;}
.xl7326196
	{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]>&nbsp;&nbsp;<![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_26196" 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=121 style='mso-width-source:userset;mso-width-alt:4425;width:91pt'>
 <col width=99 style='mso-width-source:userset;mso-width-alt:3620;width:74pt'>
 <col width=64 span=5 style='width:48pt'>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl6626196 width=121 style='height:12.75pt;width:91pt'>Machine
  details</td>
  <td class=xl1526196 width=99 style='width:74pt'></td>
  <td class=xl1526196 width=64 style='width:48pt'></td>
  <td class=xl1526196 width=64 style='width:48pt'></td>
  <td class=xl1526196 width=64 style='width:48pt'></td>
  <td class=xl1526196 width=64 style='width:48pt'></td>
  <td class=xl1526196 width=64 style='width:48pt'></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl6526196 style='height:12.75pt'>CPU</td>
  <td class=xl6826196 style='border-left:none'>8 core</td>
  <td class=xl1526196></td>
  <td class=xl1526196></td>
  <td class=xl1526196></td>
  <td class=xl1526196></td>
  <td class=xl1526196></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl6526196 style='height:12.75pt;border-top:none'>OS</td>
  <td class=xl6826196 style='border-top:none;border-left:none'>suse linux 10.3</td>
  <td class=xl1526196></td>
  <td class=xl1526196></td>
  <td class=xl1526196></td>
  <td class=xl1526196></td>
  <td class=xl1526196></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl6526196 style='height:12.75pt;border-top:none'>RAM</td>
  <td class=xl6826196 style='border-top:none;border-left:none'>24GB</td>
  <td class=xl1526196></td>
  <td class=xl1526196></td>
  <td class=xl1526196></td>
  <td class=xl1526196></td>
  <td class=xl1526196></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl1526196 style='height:12.75pt'></td>
  <td class=xl1526196></td>
  <td class=xl1526196></td>
  <td class=xl1526196></td>
  <td class=xl1526196></td>
  <td class=xl1526196></td>
  <td class=xl1526196></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl6626196 colspan=2 style='height:12.75pt'>Server
  Configuration</td>
  <td class=xl1526196></td>
  <td class=xl1526196></td>
  <td class=xl1526196></td>
  <td class=xl1526196></td>
  <td class=xl1526196></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl6526196 style='height:12.75pt'>sync commit</td>
  <td class=xl6826196 style='border-left:none'>off</td>
  <td class=xl1526196></td>
  <td class=xl1526196></td>
  <td class=xl1526196></td>
  <td class=xl1526196></td>
  <td class=xl1526196></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl6526196 style='height:12.75pt;border-top:none'>shared
  buffers</td>
  <td class=xl6826196 style='border-top:none;border-left:none'>1GB</td>
  <td class=xl1526196></td>
  <td class=xl1526196></td>
  <td class=xl1526196></td>
  <td class=xl1526196></td>
  <td class=xl1526196></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl6526196 style='height:12.75pt;border-top:none'>ckpt
  segments</td>
  <td class=xl6826196 style='border-top:none;border-left:none'>256</td>
  <td class=xl1526196></td>
  <td class=xl1526196></td>
  <td class=xl1526196></td>
  <td class=xl1526196></td>
  <td class=xl1526196></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl6526196 style='height:12.75pt;border-top:none'>ckpt
  interval</td>
  <td class=xl6826196 style='border-top:none;border-left:none'>15Min</td>
  <td class=xl1526196></td>
  <td class=xl1526196></td>
  <td class=xl1526196></td>
  <td class=xl1526196></td>
  <td class=xl1526196></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl1526196 style='height:12.75pt'></td>
  <td class=xl1526196></td>
  <td class=xl1526196></td>
  <td class=xl1526196></td>
  <td class=xl1526196></td>
  <td class=xl1526196></td>
  <td class=xl1526196></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl6626196 colspan=2 style='height:12.75pt'>Pgbench tcp_b
  benchmark suite</td>
  <td class=xl1526196></td>
  <td class=xl1526196></td>
  <td class=xl1526196></td>
  <td class=xl1526196></td>
  <td class=xl1526196></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl6526196 style='height:12.75pt'>threads</td>
  <td class=xl6526196 align=right style='border-left:none'>8</td>
  <td class=xl1526196></td>
  <td class=xl1526196></td>
  <td class=xl1526196></td>
  <td class=xl1526196></td>
  <td class=xl1526196></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl6526196 style='height:12.75pt;border-top:none'>clients</td>
  <td class=xl6526196 align=right style='border-top:none;border-left:none'>16</td>
  <td class=xl1526196></td>
  <td class=xl1526196></td>
  <td class=xl1526196></td>
  <td class=xl1526196></td>
  <td class=xl1526196></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl6526196 style='height:12.75pt;border-top:none'>scale</td>
  <td class=xl6526196 align=right style='border-top:none;border-left:none'>75</td>
  <td class=xl1526196></td>
  <td class=xl1526196></td>
  <td class=xl1526196></td>
  <td class=xl1526196></td>
  <td class=xl1526196></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl6526196 style='height:12.75pt;border-top:none'>fill
  factor</td>
  <td class=xl6526196 align=right style='border-top:none;border-left:none'>100</td>
  <td class=xl1526196></td>
  <td class=xl1526196></td>
  <td class=xl1526196></td>
  <td class=xl1526196></td>
  <td class=xl1526196></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl6526196 style='height:12.75pt;border-top:none'>only
  update</td>
  <td class=xl6826196 style='border-top:none;border-left:none'>No</td>
  <td class=xl1526196></td>
  <td class=xl1526196></td>
  <td class=xl1526196></td>
  <td class=xl1526196></td>
  <td class=xl1526196></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl6526196 style='height:12.75pt;border-top:none'>one
  record size</td>
  <td class=xl6826196 style='border-top:none;border-left:none'>120 bytes</td>
  <td class=xl1526196></td>
  <td class=xl1526196></td>
  <td class=xl1526196></td>
  <td class=xl1526196></td>
  <td class=xl1526196></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl6526196 style='height:12.75pt;border-top:none'>update
  column size</td>
  <td class=xl6826196 style='border-top:none;border-left:none'>4 bytes</td>
  <td class=xl1526196></td>
  <td class=xl1526196></td>
  <td class=xl1526196></td>
  <td class=xl1526196></td>
  <td class=xl1526196></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl1526196 style='height:12.75pt'></td>
  <td class=xl1526196></td>
  <td class=xl1526196></td>
  <td class=xl1526196></td>
  <td class=xl1526196></td>
  <td class=xl1526196></td>
  <td class=xl1526196></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl1526196 style='height:12.75pt'></td>
  <td class=xl1526196></td>
  <td class=xl1526196></td>
  <td class=xl1526196></td>
  <td class=xl1526196></td>
  <td class=xl1526196></td>
  <td class=xl1526196></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td rowspan=2 height=34 class=xl7026196 style='border-bottom:.5pt solid black;
  height:25.5pt'>pgbench<span style='mso-spacerun:yes'>&nbsp;</span></td>
  <td colspan=2 class=xl7226196 style='border-right:.5pt solid black;
  border-left:none'>old code</td>
  <td colspan=2 class=xl7226196 style='border-right:.5pt solid black;
  border-left:none'>Modified code</td>
  <td colspan=2 class=xl7226196 style='border-right:.5pt solid black;
  border-left:none'>Difference(%)</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl6426196 style='height:12.75pt;border-top:none;
  border-left:none'>TPS</td>
  <td class=xl6426196 style='border-top:none;border-left:none'>Total</td>
  <td class=xl6426196 style='border-top:none;border-left:none'>TPS</td>
  <td class=xl6426196 style='border-top:none;border-left:none'>Total</td>
  <td class=xl6426196 style='border-top:none;border-left:none'>TPS</td>
  <td class=xl6426196 style='border-top:none;border-left:none'>Total</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl6326196 style='height:12.75pt;border-top:none'>Run1</td>
  <td class=xl6926196 align=right style='border-top:none;border-left:none'>7290</td>
  <td class=xl1526196 align=right>4378475</td>
  <td class=xl6526196 align=right style='border-top:none'>8298</td>
  <td class=xl6526196 align=right style='border-top:none;border-left:none'>4984243</td>
  <td class=xl6526196 align=right style='border-top:none;border-left:none'>13.82716</td>
  <td class=xl6526196 align=right style='border-top:none;border-left:none'>13.83514</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl6326196 style='height:12.75pt;border-top:none'>Run2</td>
  <td class=xl6526196 align=right style='border-left:none'>7614</td>
  <td class=xl6526196 align=right style='border-left:none'>4571083</td>
  <td class=xl6526196 align=right style='border-top:none;border-left:none'>8815</td>
  <td class=xl6526196 align=right style='border-top:none;border-left:none'>5292404</td>
  <td class=xl6526196 align=right style='border-top:none;border-left:none'>15.77357</td>
  <td class=xl6526196 align=right style='border-top:none;border-left:none'>15.78009</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl6326196 style='height:12.75pt;border-top:none'>Run3</td>
  <td class=xl6526196 align=right style='border-top:none;border-left:none'>7797</td>
  <td class=xl6526196 align=right style='border-top:none;border-left:none'>4688831</td>
  <td class=xl6526196 align=right style='border-top:none;border-left:none'>8550</td>
  <td class=xl6526196 align=right style='border-top:none;border-left:none'>5156011</td>
  <td class=xl6526196 align=right style='border-top:none;border-left:none'>9.657561</td>
  <td class=xl6526196 align=right style='border-top:none;border-left:none'>9.963678</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl6326196 style='height:12.75pt;border-top:none'>Avg</td>
  <td class=xl6526196 align=right style='border-top:none;border-left:none'>7567</td>
  <td class=xl6526196 align=right style='border-top:none;border-left:none'>4546130</td>
  <td class=xl6526196 align=right style='border-top:none;border-left:none'>8554.333</td>
  <td class=xl6526196 align=right style='border-top:none;border-left:none'>5144219</td>
  <td class=xl6726196 align=right style='border-top:none;border-left:none'>13.04788</td>
  <td class=xl6726196 align=right style='border-top:none;border-left:none'>13.15602</td>
 </tr>
 <![if supportMisalignedColumns]>
 <tr height=0 style='display:none'>
  <td width=121 style='width:91pt'></td>
  <td width=99 style='width:74pt'></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>