pgbench_test_50_and_100.htm

text/html

Filename: pgbench_test_50_and_100.htm
Type: text/html
Part: 0
Message: Re: Re: [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_test_50_and_100_files/filelist.xml">
<style id="pgbench_var_23598_Styles">
<!--table
	{mso-displayed-decimal-separator:"\.";
	mso-displayed-thousand-separator:"\,";}
.xl1523598
	{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;}
.xl6323598
	{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;}
.xl6423598
	{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;}
.xl6523598
	{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;}
.xl6623598
	{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;}
.xl6723598
	{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;}
.xl6823598
	{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;}
.xl6923598
	{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;}
.xl7023598
	{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;}
.xl7123598
	{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;}
.xl7223598
	{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;}
.xl7323598
	{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;}
.xl7423598
	{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: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_var_23598" align=center x:publishsource="Excel">

<table border=0 cellpadding=0 cellspacing=0 width=782 style='border-collapse:
 collapse;table-layout:fixed;width:587pt'>
 <col width=64 style='width:48pt'>
 <col width=96 style='mso-width-source:userset;mso-width-alt:3510;width:72pt'>
 <col width=64 span=5 style='width:48pt'>
 <col width=86 style='mso-width-source:userset;mso-width-alt:3145;width:65pt'>
 <col width=64 style='width:48pt'>
 <col width=88 style='mso-width-source:userset;mso-width-alt:3218;width:66pt'>
 <col width=64 style='width:48pt'>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl1523598 width=64 style='height:12.75pt;width:48pt'></td>
  <td class=xl1523598 width=96 style='width:72pt'></td>
  <td class=xl1523598 width=64 style='width:48pt'></td>
  <td class=xl1523598 width=64 style='width:48pt'></td>
  <td class=xl1523598 width=64 style='width:48pt'></td>
  <td class=xl1523598 width=64 style='width:48pt'></td>
  <td class=xl1523598 width=64 style='width:48pt'></td>
  <td class=xl1523598 width=86 style='width:65pt'></td>
  <td class=xl1523598 width=64 style='width:48pt'></td>
  <td class=xl1523598 width=88 style='width:66pt'></td>
  <td class=xl1523598 width=64 style='width:48pt'></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl6623598 colspan=2 style='height:12.75pt'>Machine
  details</td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl6423598>Base records</td>
  <td class=xl6423598 align=right style='border-left:none'>1000000</td>
  <td class=xl6423598 style='border-left:none'>fill factor</td>
  <td class=xl6423598 align=right style='border-left:none'>100</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl6423598 style='height:12.75pt'>CPU</td>
  <td class=xl6723598 style='border-left:none'>8 core</td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl6423598 style='border-top:none'>update</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>3</td>
  <td class=xl6423598 style='border-top:none;border-left:none'>shared buffers</td>
  <td class=xl6723598 style='border-top:none;border-left:none'>2GB</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl6423598 style='height:12.75pt;border-top:none'>OS</td>
  <td class=xl6723598 style='border-top:none;border-left:none'>suse linux 10.3</td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl6423598 style='border-top:none'>record size</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>1800</td>
  <td class=xl6423598 style='border-top:none;border-left:none'>update size</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>250</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl6423598 style='height:12.75pt;border-top:none'>RAM</td>
  <td class=xl6723598 style='border-top:none;border-left:none'>24GB</td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl6423598 style='border-top:none'>threads</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>8</td>
  <td class=xl6423598 style='border-top:none;border-left:none'>clients</td>
  <td class=xl6723598 style='border-top:none;border-left:none'>16</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl1523598 style='height:12.75pt'></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl6423598 style='border-top:none'>auto vacuum</td>
  <td class=xl6723598 style='border-top:none;border-left:none'>off</td>
  <td class=xl6423598 style='border-top:none;border-left:none'>wal page size</td>
  <td class=xl6723598 style='border-top:none;border-left:none'>1K</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl1523598 style='height:12.75pt'></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl6423598 style='border-top:none'>ckpt seg</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>256</td>
  <td class=xl6423598 style='border-top:none;border-left:none'>ckpt interval</td>
  <td class=xl6723598 style='border-top:none;border-left:none'>15min</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl1523598 style='height:12.75pt'></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl6423598 style='border-top:none'>sync commit<span
  style='mso-spacerun:yes'>&nbsp;</span></td>
  <td class=xl6723598 style='border-top:none;border-left:none'>off</td>
  <td class=xl6423598 style='border-top:none;border-left:none'>&nbsp;</td>
  <td class=xl6423598 style='border-top:none;border-left:none'>&nbsp;</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl6623598 colspan=2 style='height:12.75pt'>50 rec
  modified</td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl1523598 style='height:12.75pt'></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl6623598 style='height:12.75pt'>fill factor<span
  style='mso-spacerun:yes'>&nbsp;</span></td>
  <td class=xl6623598 align=right>100</td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl1523598 style='height:12.75pt'></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl6823598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td rowspan=2 height=34 class=xl7023598 style='border-bottom:.5pt solid black;
  height:25.5pt'>pgbench<span style='mso-spacerun:yes'>&nbsp;</span></td>
  <td colspan=2 class=xl7223598 style='border-right:.5pt solid black;
  border-left:none'>old code</td>
  <td colspan=2 class=xl7223598 style='border-right:.5pt solid black;
  border-left:none'>Modified code</td>
  <td colspan=2 class=xl7223598 style='border-right:.5pt solid black;
  border-left:none'>Difference(%)</td>
  <td colspan=2 class=xl7223598 style='border-right:.5pt solid black;
  border-left:none'>LZ code</td>
  <td colspan=2 class=xl7223598 style='border-left:none'>Difference(%)</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl6923598 style='height:12.75pt;border-top:none;
  border-left:none'>TPS</td>
  <td class=xl6923598 style='border-top:none;border-left:none'>Total</td>
  <td class=xl6923598 style='border-top:none;border-left:none'>TPS</td>
  <td class=xl6923598 style='border-top:none;border-left:none'>Total</td>
  <td class=xl6923598 style='border-top:none;border-left:none'>TPS</td>
  <td class=xl6923598 style='border-top:none;border-left:none'>Total</td>
  <td class=xl6923598 style='border-top:none;border-left:none'>TPS</td>
  <td class=xl6923598 style='border-top:none;border-left:none'>Total</td>
  <td class=xl6923598 style='border-top:none;border-left:none'>TPS</td>
  <td class=xl6923598 style='border-top:none;border-left:none'>Total</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl6323598 style='height:12.75pt;border-top:none'>Run1</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>1522</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>918988</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>2699</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>1623935</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>77.33246</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>76.70905</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>2552</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>1534038</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>67.67411301</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>66.92688</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl6323598 style='height:12.75pt;border-top:none'>Run2</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>1496</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>902229</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>2501</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>1501300</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>67.17914</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>66.399</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>2553</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>1534329</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>70.65508021</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>70.05982</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl6323598 style='height:12.75pt;border-top:none'>Run3</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>1530</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>920689</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>2916</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>1750731</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>90.58824</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>90.15444</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>2561</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>1537745</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>67.38562092</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>67.02111</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl6323598 style='height:12.75pt;border-top:none'>Avg</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>1516</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>913968.7</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>2705.333</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>1625322</td>
  <td class=xl6523598 align=right style='border-top:none;border-left:none'>78.36661</td>
  <td class=xl6523598 align=right style='border-top:none;border-left:none'>77.75416</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>2555.333333</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>1535371</td>
  <td class=xl6523598 align=right style='border-top:none;border-left:none'>68.57160471</td>
  <td class=xl6523598 align=right style='border-top:none;border-left:none'>68.0026</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl1523598 style='height:12.75pt'></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl6823598></td>
  <td class=xl1523598></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl1523598 style='height:12.75pt'></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl1523598 style='height:12.75pt'></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl6623598 style='height:12.75pt'>fill factor</td>
  <td class=xl6623598 align=right>80</td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl1523598 style='height:12.75pt'></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td rowspan=2 height=34 class=xl7023598 style='border-bottom:.5pt solid black;
  height:25.5pt'>pgbench<span style='mso-spacerun:yes'>&nbsp;</span></td>
  <td colspan=2 class=xl7223598 style='border-right:.5pt solid black;
  border-left:none'>old code</td>
  <td colspan=2 class=xl7223598 style='border-right:.5pt solid black;
  border-left:none'>Modified code</td>
  <td colspan=2 class=xl7223598 style='border-right:.5pt solid black;
  border-left:none'>Difference(%)</td>
  <td colspan=2 class=xl7223598 style='border-right:.5pt solid black;
  border-left:none'>LZ code</td>
  <td colspan=2 class=xl7223598 style='border-left:none'>Difference(%)</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl6923598 style='height:12.75pt;border-top:none;
  border-left:none'>TPS</td>
  <td class=xl6923598 style='border-top:none;border-left:none'>Total</td>
  <td class=xl6923598 style='border-top:none;border-left:none'>TPS</td>
  <td class=xl6923598 style='border-top:none;border-left:none'>Total</td>
  <td class=xl6923598 style='border-top:none;border-left:none'>TPS</td>
  <td class=xl6923598 style='border-top:none;border-left:none'>Total</td>
  <td class=xl6923598 style='border-top:none;border-left:none'>TPS</td>
  <td class=xl6923598 style='border-top:none;border-left:none'>Total</td>
  <td class=xl6923598 style='border-top:none;border-left:none'>TPS</td>
  <td class=xl6923598 style='border-top:none;border-left:none'>Total</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl6323598 style='height:12.75pt;border-top:none'>Run1</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>1405</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>843755</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>3009</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>1808003</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>114.1637</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>114.2806</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>2939</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>1764813</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>109.1814947</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>109.1618</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl6323598 style='height:12.75pt;border-top:none'>Run2</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>1438</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>863822</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>3044</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>1832320</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>111.6829</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>112.1178</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>2704</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>1632143</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>88.03894298</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>88.94437</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl6323598 style='height:12.75pt;border-top:none'>Run3</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>1336</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>804222</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>3078</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>1850127</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>130.3892</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>130.0518</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>2902</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>1747072</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>117.2155689</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>117.2375</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl6323598 style='height:12.75pt;border-top:none'>Avg</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>1393</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>837266.3</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>3043.667</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>1830150</td>
  <td class=xl6523598 align=right style='border-top:none;border-left:none'>118.7453</td>
  <td class=xl6523598 align=right style='border-top:none;border-left:none'>118.8167</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>2848.333333</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>1714676</td>
  <td class=xl6523598 align=right style='border-top:none;border-left:none'>104.8120022</td>
  <td class=xl6523598 align=right style='border-top:none;border-left:none'>105.1146</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl1523598 style='height:12.75pt'></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl1523598 style='height:12.75pt'></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl1523598 style='height:12.75pt'></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl1523598 style='height:12.75pt'></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl1523598 style='height:12.75pt'></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl6623598 colspan=2 style='height:12.75pt'>100 rec
  modified</td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl1523598 style='height:12.75pt'></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl6623598 style='height:12.75pt'>fill factor<span
  style='mso-spacerun:yes'>&nbsp;</span></td>
  <td class=xl6623598 align=right>100</td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl1523598 style='height:12.75pt'></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
  <td class=xl6823598></td>
  <td class=xl1523598></td>
  <td class=xl1523598></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td rowspan=2 height=34 class=xl7023598 style='border-bottom:.5pt solid black;
  height:25.5pt'>pgbench<span style='mso-spacerun:yes'>&nbsp;</span></td>
  <td colspan=2 class=xl7223598 style='border-right:.5pt solid black;
  border-left:none'>old code</td>
  <td colspan=2 class=xl7223598 style='border-right:.5pt solid black;
  border-left:none'>Modified code</td>
  <td colspan=2 class=xl7223598 style='border-right:.5pt solid black;
  border-left:none'>Difference(%)</td>
  <td colspan=2 class=xl7223598 style='border-right:.5pt solid black;
  border-left:none'>LZ code</td>
  <td colspan=2 class=xl7223598 style='border-left:none'>Difference(%)</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl6923598 style='height:12.75pt;border-top:none;
  border-left:none'>TPS</td>
  <td class=xl6923598 style='border-top:none;border-left:none'>Total</td>
  <td class=xl6923598 style='border-top:none;border-left:none'>TPS</td>
  <td class=xl6923598 style='border-top:none;border-left:none'>Total</td>
  <td class=xl6923598 style='border-top:none;border-left:none'>TPS</td>
  <td class=xl6923598 style='border-top:none;border-left:none'>Total</td>
  <td class=xl6923598 style='border-top:none;border-left:none'>TPS</td>
  <td class=xl6923598 style='border-top:none;border-left:none'>Total</td>
  <td class=xl6923598 style='border-top:none;border-left:none'>TPS</td>
  <td class=xl6923598 style='border-top:none;border-left:none'>Total</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl6323598 style='height:12.75pt;border-top:none'>Run1</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>1507</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>911814</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>2463</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>1482359</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>63.43729</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>62.57252</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>2317</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>1394032</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>53.74917054</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>52.88557</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl6323598 style='height:12.75pt;border-top:none'>Run2</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>1372</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>825130</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>2362</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>1418223</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>72.15743</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>71.87873</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>2757</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>1655922</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>100.9475219</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>100.6862</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl6323598 style='height:12.75pt;border-top:none'>Run3</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>1491</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>895871</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>2793</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>1685273</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>87.32394</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>88.11559</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>2416</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>1450910</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>62.03890007</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>61.95524</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl6323598 style='height:12.75pt;border-top:none'>Avg</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>1456.666667</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>877605</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>2539.333</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>1528618</td>
  <td class=xl6523598 align=right style='border-top:none;border-left:none'>74.30622</td>
  <td class=xl6523598 align=right style='border-top:none;border-left:none'>74.18895</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>2496.666667</td>
  <td class=xl6423598 align=right style='border-top:none;border-left:none'>1500288</td>
  <td class=xl6523598 align=right style='border-top:none;border-left:none'>72.24519749</td>
  <td class=xl6523598 align=right style='border-top:none;border-left:none'>71.84233</td>
 </tr>
 <![if supportMisalignedColumns]>
 <tr height=0 style='display:none'>
  <td width=64 style='width:48pt'></td>
  <td width=96 style='width:72pt'></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>
  <td width=86 style='width:65pt'></td>
  <td width=64 style='width:48pt'></td>
  <td width=88 style='width:66pt'></td>
  <td width=64 style='width:48pt'></td>
 </tr>
 <![endif]>
</table>

</div>


<!----------------------------->
<!--END OF OUTPUT FROM EXCEL PUBLISH AS WEB PAGE WIZARD-->
<!----------------------------->
</body>

</html>