pgbench_wal_modified_and_lz_random_test.htm

text/html

Filename: pgbench_wal_modified_and_lz_random_test.htm
Type: text/html
Part: 3
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_wal_modified_and_lz_test_files/filelist.xml">
<style id="pgbench_var_22034_Styles">
<!--table
	{mso-displayed-decimal-separator:"\.";
	mso-displayed-thousand-separator:"\,";}
.xl1522034
	{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;}
.xl6322034
	{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;}
.xl6422034
	{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;}
.xl6522034
	{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;}
.xl6622034
	{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;}
.xl6722034
	{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;}
.xl6822034
	{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;}
.xl6922034
	{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;}
.xl7022034
	{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;}
.xl7122034
	{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;}
.xl7222034
	{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;}
.xl7322034
	{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;}
.xl7422034
	{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_22034" align=center x:publishsource="Excel">

<table border=0 cellpadding=0 cellspacing=0 width=794 style='border-collapse:
 collapse;table-layout:fixed;width:596pt'>
 <col width=108 style='mso-width-source:userset;mso-width-alt:3949;width:81pt'>
 <col width=64 span=6 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=xl1522034 width=108 style='height:12.75pt;width:81pt'></td>
  <td class=xl1522034 width=64 style='width:48pt'></td>
  <td class=xl1522034 width=64 style='width:48pt'></td>
  <td class=xl1522034 width=64 style='width:48pt'></td>
  <td class=xl1522034 width=64 style='width:48pt'></td>
  <td class=xl1522034 width=64 style='width:48pt'></td>
  <td class=xl1522034 width=64 style='width:48pt'></td>
  <td class=xl1522034 width=86 style='width:65pt'></td>
  <td class=xl1522034 width=64 style='width:48pt'></td>
  <td class=xl1522034 width=88 style='width:66pt'></td>
  <td class=xl1522034 width=64 style='width:48pt'></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl1522034 style='height:12.75pt'></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl6722034 style='height:12.75pt'>Machine details</td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl6522034>Base records</td>
  <td class=xl6522034 align=right style='border-left:none'>1000000</td>
  <td class=xl6522034 style='border-left:none'>fill factor</td>
  <td class=xl6522034 align=right style='border-left:none'>100</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl6522034 style='height:12.75pt'>CPU</td>
  <td class=xl6822034 style='border-left:none'>8 core</td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl6522034 style='border-top:none'>update</td>
  <td class=xl6522034 align=right style='border-top:none;border-left:none'>3</td>
  <td class=xl6522034 style='border-top:none;border-left:none'>shared buffers</td>
  <td class=xl6822034 style='border-top:none;border-left:none'>2GB</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl6522034 style='height:12.75pt;border-top:none'>OS</td>
  <td class=xl6822034 style='border-top:none;border-left:none'>suse linux 10.3</td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl6522034 style='border-top:none'>record size</td>
  <td class=xl6522034 align=right style='border-top:none;border-left:none'>1800</td>
  <td class=xl6522034 style='border-top:none;border-left:none'>update size</td>
  <td class=xl6522034 align=right style='border-top:none;border-left:none'>250</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl6522034 style='height:12.75pt;border-top:none'>RAM</td>
  <td class=xl6822034 style='border-top:none;border-left:none'>24GB</td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl6522034 style='border-top:none'>threads</td>
  <td class=xl6522034 align=right style='border-top:none;border-left:none'>8</td>
  <td class=xl6522034 style='border-top:none;border-left:none'>clients</td>
  <td class=xl6822034 style='border-top:none;border-left:none'>16</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl1522034 style='height:12.75pt'></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl6522034 style='border-top:none'>auto vacuum</td>
  <td class=xl6822034 style='border-top:none;border-left:none'>off</td>
  <td class=xl6522034 style='border-top:none;border-left:none'>wal page size</td>
  <td class=xl6822034 style='border-top:none;border-left:none'>1K</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl1522034 style='height:12.75pt'></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl6522034 style='border-top:none'>ckpt seg</td>
  <td class=xl6522034 align=right style='border-top:none;border-left:none'>256</td>
  <td class=xl6522034 style='border-top:none;border-left:none'>ckpt interval</td>
  <td class=xl6822034 style='border-top:none;border-left:none'>15min</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl1522034 style='height:12.75pt'></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl6522034 style='border-top:none'>sync commit<span
  style='mso-spacerun:yes'>&nbsp;</span></td>
  <td class=xl6822034 style='border-top:none;border-left:none'>off</td>
  <td class=xl6522034 style='border-top:none;border-left:none'>&nbsp;</td>
  <td class=xl6522034 style='border-top:none;border-left:none'>&nbsp;</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl1522034 style='height:12.75pt'></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl6722034 style='height:12.75pt'>Random string</td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl1522034 style='height:12.75pt'></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl6722034 style='height:12.75pt'>fill factor<span
  style='mso-spacerun:yes'>&nbsp;</span></td>
  <td class=xl6722034 align=right>100</td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl1522034 style='height:12.75pt'></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl6922034></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td rowspan=2 height=34 class=xl7022034 style='border-bottom:.5pt solid black;
  height:25.5pt'>pgbench<span style='mso-spacerun:yes'>&nbsp;</span></td>
  <td colspan=2 class=xl7222034 style='border-right:.5pt solid black;
  border-left:none'>Original code</td>
  <td colspan=2 class=xl7222034 style='border-right:.5pt solid black;
  border-left:none'>Wal Modified code</td>
  <td colspan=2 class=xl7222034 style='border-right:.5pt solid black;
  border-left:none'>Difference(%)</td>
  <td colspan=2 class=xl6322034 style='border-left:none'>LZ code</td>
  <td colspan=2 class=xl6322034 style='border-left:none'>Difference(%)</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl6322034 style='height:12.75pt;border-top:none;
  border-left:none'>TPS</td>
  <td class=xl6322034 style='border-top:none;border-left:none'>Total</td>
  <td class=xl6322034 style='border-top:none;border-left:none'>TPS</td>
  <td class=xl6322034 style='border-top:none;border-left:none'>Total</td>
  <td class=xl6322034 style='border-top:none;border-left:none'>TPS</td>
  <td class=xl6322034 style='border-top:none;border-left:none'>Total</td>
  <td class=xl6322034 style='border-top:none;border-left:none'>TPS</td>
  <td class=xl6322034 style='border-top:none;border-left:none'>Total</td>
  <td class=xl6322034 style='border-top:none;border-left:none'>TPS</td>
  <td class=xl6322034 style='border-top:none;border-left:none'>Total</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl6422034 style='height:12.75pt;border-top:none'>Run1</td>
  <td class=xl6522034 align=right style='border-top:none;border-left:none'>905</td>
  <td class=xl6522034 align=right style='border-top:none;border-left:none'>545253</td>
  <td class=xl6522034 align=right style='border-top:none;border-left:none'>1395</td>
  <td class=xl6522034 align=right style='border-top:none;border-left:none'>838421</td>
  <td class=xl6522034 align=right style='border-top:none;border-left:none'>54.14365</td>
  <td class=xl6522034 align=right style='border-top:none;border-left:none'>53.76733</td>
  <td class=xl6522034 align=right style='border-top:none;border-left:none'>1446</td>
  <td class=xl6522034 align=right style='border-top:none;border-left:none'>870938</td>
  <td class=xl6522034 align=right style='border-top:none;border-left:none'>59.77900552</td>
  <td class=xl6522034 align=right style='border-top:none;border-left:none'>59.73099</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl6422034 style='height:12.75pt;border-top:none'>Run2</td>
  <td class=xl6522034 align=right style='border-top:none;border-left:none'>995</td>
  <td class=xl6522034 align=right style='border-top:none;border-left:none'>598687</td>
  <td class=xl6522034 align=right style='border-top:none;border-left:none'>1455</td>
  <td class=xl6522034 align=right style='border-top:none;border-left:none'>874202</td>
  <td class=xl6522034 align=right style='border-top:none;border-left:none'>46.23116</td>
  <td class=xl6522034 align=right style='border-top:none;border-left:none'>46.01987</td>
  <td class=xl6522034 align=right style='border-top:none;border-left:none'>1441</td>
  <td class=xl6522034 align=right style='border-top:none;border-left:none'>865342</td>
  <td class=xl6522034 align=right style='border-top:none;border-left:none'>44.8241206</td>
  <td class=xl6522034 align=right style='border-top:none;border-left:none'>44.53997</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl6422034 style='height:12.75pt;border-top:none'>Run3</td>
  <td class=xl6522034 align=right style='border-top:none;border-left:none'>1003</td>
  <td class=xl6522034 align=right style='border-top:none;border-left:none'>602998</td>
  <td class=xl6522034 align=right style='border-top:none;border-left:none'>1386</td>
  <td class=xl6522034 align=right style='border-top:none;border-left:none'>834458</td>
  <td class=xl6522034 align=right style='border-top:none;border-left:none'>38.18544</td>
  <td class=xl6522034 align=right style='border-top:none;border-left:none'>38.38487</td>
  <td class=xl6522034 align=right style='border-top:none;border-left:none'>1485</td>
  <td class=xl6522034 align=right style='border-top:none;border-left:none'>892966</td>
  <td class=xl6522034 align=right style='border-top:none;border-left:none'>48.0558325</td>
  <td class=xl6522034 align=right style='border-top:none;border-left:none'>48.08772</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl6422034 style='height:12.75pt;border-top:none'>Avg</td>
  <td class=xl6522034 align=right style='border-top:none;border-left:none'>967.6667</td>
  <td class=xl6522034 align=right style='border-top:none;border-left:none'>582312.7</td>
  <td class=xl6522034 align=right style='border-top:none;border-left:none'>1412</td>
  <td class=xl6522034 align=right style='border-top:none;border-left:none'>849027</td>
  <td class=xl6622034 align=right style='border-top:none;border-left:none'>46.18675</td>
  <td class=xl6622034 align=right style='border-top:none;border-left:none'>46.05736</td>
  <td class=xl6522034 align=right style='border-top:none;border-left:none'>1457.333333</td>
  <td class=xl6522034 align=right style='border-top:none;border-left:none'>876415.3</td>
  <td class=xl6622034 align=right style='border-top:none;border-left:none'>50.88631954</td>
  <td class=xl6622034 align=right style='border-top:none;border-left:none'>50.78623</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl1522034 style='height:12.75pt'></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl6922034></td>
  <td class=xl1522034></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl1522034 style='height:12.75pt'></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl1522034 style='height:12.75pt'></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl6722034 style='height:12.75pt'>fill factor</td>
  <td class=xl6722034 align=right>80</td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl1522034 style='height:12.75pt'></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
  <td class=xl1522034></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td rowspan=2 height=34 class=xl7022034 style='border-bottom:.5pt solid black;
  height:25.5pt'>pgbench<span style='mso-spacerun:yes'>&nbsp;</span></td>
  <td colspan=2 class=xl7222034 style='border-right:.5pt solid black;
  border-left:none'>Original code</td>
  <td colspan=2 class=xl7222034 style='border-right:.5pt solid black;
  border-left:none'>Wal Modified code</td>
  <td colspan=2 class=xl7222034 style='border-right:.5pt solid black;
  border-left:none'>Difference(%)</td>
  <td colspan=2 class=xl7222034 style='border-right:.5pt solid black;
  border-left:none'>LZ code</td>
  <td colspan=2 class=xl7222034 style='border-left:none'>Difference(%)</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl6322034 style='height:12.75pt;border-top:none;
  border-left:none'>TPS</td>
  <td class=xl6322034 style='border-top:none;border-left:none'>Total</td>
  <td class=xl6322034 style='border-top:none;border-left:none'>TPS</td>
  <td class=xl6322034 style='border-top:none;border-left:none'>Total</td>
  <td class=xl6322034 style='border-top:none;border-left:none'>TPS</td>
  <td class=xl6322034 style='border-top:none;border-left:none'>Total</td>
  <td class=xl6322034 style='border-top:none;border-left:none'>TPS</td>
  <td class=xl6322034 style='border-top:none;border-left:none'>Total</td>
  <td class=xl6322034 style='border-top:none;border-left:none'>TPS</td>
  <td class=xl6322034 style='border-top:none;border-left:none'>Total</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl6422034 style='height:12.75pt;border-top:none'>Run1</td>
  <td class=xl6522034 align=right style='border-top:none;border-left:none'>1302</td>
  <td class=xl6522034 align=right style='border-top:none;border-left:none'>781997</td>
  <td class=xl6522034 align=right style='border-top:none;border-left:none'>2234</td>
  <td class=xl6522034 align=right style='border-top:none;border-left:none'>1342166</td>
  <td class=xl6522034 align=right style='border-top:none;border-left:none'>71.58218</td>
  <td class=xl6522034 align=right style='border-top:none;border-left:none'>71.63314</td>
  <td class=xl6522034 align=right style='border-top:none;border-left:none'>2319</td>
  <td class=xl6522034 align=right style='border-top:none;border-left:none'>1392679</td>
  <td class=xl6522034 align=right style='border-top:none;border-left:none'>78.11059908</td>
  <td class=xl6522034 align=right style='border-top:none;border-left:none'>78.09263</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl6422034 style='height:12.75pt;border-top:none'>Run2</td>
  <td class=xl6522034 align=right style='border-top:none;border-left:none'>1434</td>
  <td class=xl6522034 align=right style='border-top:none;border-left:none'>861746</td>
  <td class=xl6522034 align=right style='border-top:none;border-left:none'>2829</td>
  <td class=xl6522034 align=right style='border-top:none;border-left:none'>1699465</td>
  <td class=xl6522034 align=right style='border-top:none;border-left:none'>97.28033</td>
  <td class=xl6522034 align=right style='border-top:none;border-left:none'>97.21182</td>
  <td class=xl6522034 align=right style='border-top:none;border-left:none'>3134</td>
  <td class=xl6522034 align=right style='border-top:none;border-left:none'>1882053</td>
  <td class=xl6522034 align=right style='border-top:none;border-left:none'>118.5495119</td>
  <td class=xl6522034 align=right style='border-top:none;border-left:none'>118.4</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl6422034 style='height:12.75pt;border-top:none'>Run3</td>
  <td class=xl6522034 align=right style='border-top:none;border-left:none'>1497</td>
  <td class=xl6522034 align=right style='border-top:none;border-left:none'>899952</td>
  <td class=xl6522034 align=right style='border-top:none;border-left:none'>2280</td>
  <td class=xl6522034 align=right style='border-top:none;border-left:none'>1373820</td>
  <td class=xl6522034 align=right style='border-top:none;border-left:none'>52.30461</td>
  <td class=xl6522034 align=right style='border-top:none;border-left:none'>52.65481</td>
  <td class=xl6522034 align=right style='border-top:none;border-left:none'>2003</td>
  <td class=xl6522034 align=right style='border-top:none;border-left:none'>1209520</td>
  <td class=xl6522034 align=right style='border-top:none;border-left:none'>33.8009352</td>
  <td class=xl6522034 align=right style='border-top:none;border-left:none'>34.39828</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl6422034 style='height:12.75pt;border-top:none'>Avg</td>
  <td class=xl6522034 align=right style='border-top:none;border-left:none'>1411</td>
  <td class=xl6522034 align=right style='border-top:none;border-left:none'>847898.3</td>
  <td class=xl6522034 align=right style='border-top:none;border-left:none'>2447.667</td>
  <td class=xl6522034 align=right style='border-top:none;border-left:none'>1471817</td>
  <td class=xl6622034 align=right style='border-top:none;border-left:none'>73.72238</td>
  <td class=xl6622034 align=right style='border-top:none;border-left:none'>73.83326</td>
  <td class=xl6522034 align=right style='border-top:none;border-left:none'>2485.333333</td>
  <td class=xl6522034 align=right style='border-top:none;border-left:none'>1494751</td>
  <td class=xl6622034 align=right style='border-top:none;border-left:none'>76.82034871</td>
  <td class=xl6622034 align=right style='border-top:none;border-left:none'>76.96363</td>
 </tr>
 <![if supportMisalignedColumns]>
 <tr height=0 style='display:none'>
  <td width=108 style='width:81pt'></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=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>