pg.ddx.io  pgsql-hackers@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Amit Kapila <amit.kapila@huawei.com>
To: 'Robert Haas' <robertmhaas@gmail.com>
Cc: 'Greg Smith' <greg@2ndquadrant.com>
Cc: 'PostgreSQL-development' <pgsql-hackers@postgresql.org>
Subject: Re: Move unused buffers to freelist
Date: Thu, 6 Jun 2013 12:31:21 +0530
Message-ID: <005601ce6283$a814b410$f83e1c30$@kapila@huawei.com> (raw)
In-Reply-To: <CA+TgmoYhfcANR4ci01Gtd8YFzca=VTW9dVn9TY4RM+OdYqCPPw@mail.gmail.com>
References: <51928CDA.7030009@2ndQuadrant.com>
	<5194eb32.85d60e0a.1c17.2253SMTPIN_ADDED_BROKEN@mx.google.com>
	<CA+TgmobBckMYLvqjrsWBfc0KGBp5_eD2sPA_g3KZFN2P8p2JUA@mail.gmail.com>
	<519b1d5f.9025b40a.2d07.ffffed08SMTPIN_ADDED_BROKEN@mx.google.com>
	<CA+TgmobawHrzH0tMCgjC=_zmcJxYUo7ttawm4P2jf_tNi6dhLg@mail.gmail.com>
	<519f060c.cade440a.493f.ffffb080SMTPIN_ADDED_BROKEN@mx.google.com>
	<CA+TgmoYhfcANR4ci01Gtd8YFzca=VTW9dVn9TY4RM+OdYqCPPw@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-hackers>

On Tuesday, May 28, 2013 6:54 PM Robert Haas wrote:
> >> Instead, I suggest modifying BgBufferSync, specifically this part
> right
> >> here:
> >>
> >>         else if (buffer_state & BUF_REUSABLE)
> >>             reusable_buffers++;
> >>
> >> What I would suggest is that if the BUF_REUSABLE flag is set here,
> use
> >> that as the trigger to do StrategyMoveBufferToFreeListEnd().
> >
> > I think at this point also we need to lock buffer header to check
> refcount
> > and usage_count before moving to freelist, or do you think it is not
> > required?
> 
> If BUF_REUSABLE is set, that means we just did exactly what you're
> saying.  Why do it twice?

Even if we just did it, but we have released the buf header lock, so
theoretically chances are there that backend can increase the count, however
still it will be protected by check in StrategyGetBuffer(). As there is a
very rare chance of it, so doing without buffer header lock might not cause
any harm.
Modified patch to address the same is attached with mail. 

Performance Data
-------------------

As far as I have noticed, performance data for this patch depends on 3
factors
1. Pre-loading of data in buffers, so that buffers holding pages should have
some usage count before running pgbench. 
   Reason is it might be creating difference in performance of clock-sweep 
2. Clearing of pages in OS cache before running pgbench with different
patch, it can create difference because when we run pgbench with or without
patch, 
   it can access pages already cached due to previous runs which causes
variation in performance. 
3. Scale factor and shared buffer configuration

To avoid above 3 factors in test readings, I used below steps:
1. Initialize the database with scale factor such that database size +
shared_buffers = RAM (shared_buffers = 1/4 of RAM).
   For example: 
   Example -1
                if RAM = 128G, then initialize db with scale factor = 6700
and shared_buffers = 32GB.
                Database size (98 GB) + shared_buffers (32GB) = 130 (which
is approximately equal to total RAM)
   Example -2 (this is based on your test m/c)
                If RAM = 64GB, then initialize db with scale factor = 3400
and shared_buffers = 16GB.
2. reboot m/c
3. Load all buffers with data (tables/indexes of pgbench) using pg_prewarm.
I had loaded 3 times, so that usage count of buffers will be approximately
3.
   Used file load_all_buffers.sql attached with this mail
4. run 3 times pgbench select-only case for 10 or 15 minutes without patch
5. reboot m/c
6. Load all buffers with data (tables/indexes of pgbench) using pg_prewarm.
I had loaded 3 times, so that usage count of buffers will be approximately
3.
   Used file load_all_buffers.sql attached with this mail
7. run 3 times pgbench select-only case for 10 or 15 minutes with patch

Using above steps, I had taken performance data on 2 different m/c's

Configuration Details
O/S - Suse-11
RAM - 128GB
Number of Cores - 16
Server Conf - checkpoint_segments = 300; checkpoint_timeout = 15 min,
synchronous_commit = 0FF, shared_buffers = 32GB, AutoVacuum=off
Pgbench - Select-only
Scalefactor - 1200
Time - Each run is of 15 mins

Below data is for average of 3 runs

                   16C-16T            32C-32T            64C-64T
HEAD               4391                3971                 3464
After Patch        6147                5093                 3944

Detailed data of each run is attached with mail in file
move_unused_buffers_to_freelist_v2.htm

Below data is for 1 run of half hour on same configuration

                   16C-16T            32C-32T            64C-64T
HEAD               4377                3861                 3295
After Patch        6542                4770                 3504


Configuration Details
O/S - Suse-11
RAM - 24GB
Number of Cores - 8
Server Conf - checkpoint_segments = 256; checkpoint_timeout = 25 min,
synchronous_commit = 0FF, shared_buffers = 5GB
Pgbench - Select-only
Scalefactor - 1200
Time - Each run is of 10 mins

Below data is for average 3 runs of 10 minutes

                   8C-8T                16C-16T            32C-32T
64C-64T		128C-128T		256C-256T
HEAD               58837               56740               19390
5681		3191			2160
After Patch        59482               56936               25070
7655		4166			2704

Detailed data of each run is attached with mail in file
move_unused_buffers_to_freelist_v2.htm


Below data is for 1 run of half hour on same configuration

                   32C-32T 
HEAD               17703 
After Patch        20586 

I had run these tests multiple times to ensure the correctness. I think last
time why it didn't show performance improvement in your runs is
because the way we both are running pgbench is different. This time, I have
detailed the steps I have used to collect performance data.


With Regards,
Amit Kapila.

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Attachments:

  [application/octet-stream] move_unused_buffers_to_freelist_v2.patch (3.2K, ../005601ce6283$a814b410$f83e1c30$@kapila@huawei.com/2-move_unused_buffers_to_freelist_v2.patch)
  download | inline diff:
*** a/src/backend/storage/buffer/bufmgr.c
--- b/src/backend/storage/buffer/bufmgr.c
***************
*** 1390,1395 **** BgBufferSync(void)
--- 1390,1396 ----
  	/* Variables for final smoothed_density update */
  	long		new_strategy_delta;
  	uint32		new_recent_alloc;
+ 	volatile BufferDesc *bufHdr;
  
  	/*
  	 * Find out where the freelist clock sweep currently is, and how many
***************
*** 1575,1580 **** BgBufferSync(void)
--- 1576,1582 ----
  	{
  		int			buffer_state = SyncOneBuffer(next_to_clean, true);
  
+ 		bufHdr = &BufferDescriptors[next_to_clean];
  		if (++next_to_clean >= NBuffers)
  		{
  			next_to_clean = 0;
***************
*** 1592,1598 **** BgBufferSync(void)
--- 1594,1603 ----
  			}
  		}
  		else if (buffer_state & BUF_REUSABLE)
+ 		{
  			reusable_buffers++;
+ 			StrategyMoveBufferToFreeListEnd (bufHdr);
+ 		}                                                                      
  	}
  
  	BgWriterStats.m_buf_written_clean += num_written;
*** a/src/backend/storage/buffer/freelist.c
--- b/src/backend/storage/buffer/freelist.c
***************
*** 259,264 **** StrategyFreeBuffer(volatile BufferDesc *buf)
--- 259,296 ----
  }
  
  /*
+  * StrategyMoveBufferToFreeListEnd: put a buffer on the end of freelist
+  */                                                                                      
+ void
+ StrategyMoveBufferToFreeListEnd(volatile BufferDesc *buf)                                
+ {
+ 	LWLockAcquire(BufFreelistLock, LW_EXCLUSIVE);                                    
+  	/*
+  	 * It is possible that we are told to put something in the freelist that
+  	 * is already in it; don't screw up the list if so.
+  	 */                    
+  	if (buf->freeNext == FREENEXT_NOT_IN_LIST)
+  	{                   
+  		/*
+  		 * put the buffer on end of list and if list is empty then
+  		 * assign first and last freebuffer with this buffer id.             
+  		 */     
+  		buf->freeNext = FREENEXT_END_OF_LIST;
+  		if (StrategyControl->firstFreeBuffer < 0)                                
+  		{                
+  			StrategyControl->firstFreeBuffer = buf->buf_id;
+  			StrategyControl->lastFreeBuffer = buf->buf_id;                   
+  			LWLockRelease(BufFreelistLock);              
+  			return;                      
+  		}                                                         
+  		BufferDescriptors[StrategyControl->lastFreeBuffer].freeNext = buf->buf_id;
+  		StrategyControl->lastFreeBuffer = buf->buf_id;
+  	}
+  	LWLockRelease(BufFreelistLock);
+ }                                                                                        
+ 
+ 
+ /*
   * StrategySyncStart -- tell BufferSync where to start syncing
   *
   * The result is the buffer index of the best buffer to sync first.
*** a/src/include/storage/buf_internals.h
--- b/src/include/storage/buf_internals.h
***************
*** 185,190 **** extern BufferDesc *LocalBufferDescriptors;
--- 185,191 ----
  extern volatile BufferDesc *StrategyGetBuffer(BufferAccessStrategy strategy,
  				  bool *lock_held);
  extern void StrategyFreeBuffer(volatile BufferDesc *buf);
+ extern void StrategyMoveBufferToFreeListEnd(volatile BufferDesc *buf);
  extern bool StrategyRejectBuffer(BufferAccessStrategy strategy,
  					 volatile BufferDesc *buf);
  
=

  [text/html] move_unused_buffers_to_freelist_v2.htm (37.8K, ../005601ce6283$a814b410$f83e1c30$@kapila@huawei.com/3-move_unused_buffers_to_freelist_v2.htm)
  download | inline:
<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="move_unused_buffers_to_freelist_v2_files/filelist.xml">
<style id="move_unused_buffers_to_freelist_v2_7463_Styles">
<!--table
	{mso-displayed-decimal-separator:"\.";
	mso-displayed-thousand-separator:"\,";}
.xl157463
	{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;}
.xl637463
	{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:normal;}
.xl647463
	{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;}
.xl657463
	{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:1.0pt solid windowtext;
	border-bottom:.5pt solid windowtext;
	border-left:.5pt solid windowtext;
	mso-background-source:auto;
	mso-pattern:auto;
	white-space:nowrap;}
.xl667463
	{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:1.0pt solid windowtext;
	border-left:.5pt solid windowtext;
	mso-background-source:auto;
	mso-pattern:auto;
	white-space:nowrap;}
.xl677463
	{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:1.0pt solid windowtext;
	border-bottom:1.0pt solid windowtext;
	border-left:.5pt solid windowtext;
	mso-background-source:auto;
	mso-pattern:auto;
	white-space:nowrap;}
.xl687463
	{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:1.0pt solid windowtext;
	border-right:.5pt solid windowtext;
	border-bottom:.5pt solid windowtext;
	border-left:.5pt solid windowtext;
	background:yellow;
	mso-pattern:black none;
	white-space:nowrap;}
.xl697463
	{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:1.0pt solid windowtext;
	border-right:1.0pt solid windowtext;
	border-bottom:.5pt solid windowtext;
	border-left:.5pt solid windowtext;
	background:yellow;
	mso-pattern:black none;
	white-space:nowrap;}
.xl707463
	{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:1.0pt solid windowtext;
	border-right:.5pt solid windowtext;
	border-bottom:.5pt solid windowtext;
	border-left:1.0pt solid windowtext;
	background:yellow;
	mso-pattern:black none;
	white-space:normal;}
.xl717463
	{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:.5pt solid windowtext;
	border-left:1.0pt solid windowtext;
	mso-background-source:auto;
	mso-pattern:auto;
	white-space:normal;}
.xl727463
	{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:1.0pt solid windowtext;
	border-left:1.0pt solid windowtext;
	mso-background-source:auto;
	mso-pattern:auto;
	white-space:normal;}
.xl737463
	{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:1.0pt solid windowtext;
	border-right:.5pt solid windowtext;
	border-bottom:1.0pt solid windowtext;
	border-left:.5pt solid windowtext;
	mso-background-source:auto;
	mso-pattern:auto;
	white-space:nowrap;}
.xl747463
	{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:1.0pt solid windowtext;
	border-right:1.0pt solid windowtext;
	border-bottom:1.0pt solid windowtext;
	border-left:.5pt solid windowtext;
	mso-background-source:auto;
	mso-pattern:auto;
	white-space:nowrap;}
.xl757463
	{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:1.0pt solid windowtext;
	border-right:.5pt solid windowtext;
	border-bottom:1.0pt solid windowtext;
	border-left:1.0pt solid windowtext;
	mso-background-source:auto;
	mso-pattern:auto;
	white-space:normal;}
.xl767463
	{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-top:1.0pt solid windowtext;
	border-right:none;
	border-bottom:1.0pt solid windowtext;
	border-left:1.0pt solid windowtext;
	background:yellow;
	mso-pattern:black none;
	white-space:normal;}
.xl777463
	{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-top:1.0pt solid windowtext;
	border-right:none;
	border-bottom:1.0pt solid windowtext;
	border-left:none;
	background:yellow;
	mso-pattern:black none;
	white-space:normal;}
.xl787463
	{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-top:1.0pt solid windowtext;
	border-right:1.0pt solid windowtext;
	border-bottom:1.0pt solid windowtext;
	border-left:none;
	background:yellow;
	mso-pattern:black none;
	white-space:normal;}
-->
</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="move_unused_buffers_to_freelist_v2_7463" align=center
x:publishsource="Excel">

<table border=0 cellpadding=0 cellspacing=0 width=954 style='border-collapse:
 collapse;table-layout:fixed;width:716pt'>
 <col width=64 span=7 style='width:48pt'>
 <col width=72 style='mso-width-source:userset;mso-width-alt:2560;width:54pt'>
 <col width=434 style='mso-width-source:userset;mso-width-alt:15445;width:326pt'>
 <tr height=18 style='height:13.8pt'>
  <td height=18 class=xl157463 width=64 style='height:13.8pt;width:48pt'></td>
  <td class=xl157463 width=64 style='width:48pt'></td>
  <td class=xl157463 width=64 style='width:48pt'></td>
  <td class=xl157463 width=64 style='width:48pt'></td>
  <td class=xl157463 width=64 style='width:48pt'></td>
  <td class=xl157463 width=64 style='width:48pt'></td>
  <td class=xl157463 width=64 style='width:48pt'></td>
  <td class=xl157463 width=72 style='width:54pt'></td>
  <td class=xl157463 width=434 style='width:326pt'></td>
 </tr>
 <tr height=18 style='height:13.8pt'>
  <td height=18 class=xl157463 style='height:13.8pt'></td>
  <td colspan=2 class=xl767463 width=128 style='border-right:1.0pt solid black;
  width:96pt'>Configuration Used</td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
 </tr>
 <tr height=18 style='height:13.2pt'>
  <td height=18 class=xl157463 style='height:13.2pt'></td>
  <td class=xl157463>O/S</td>
  <td class=xl157463>Suse-11</td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
 </tr>
 <tr height=18 style='height:13.2pt'>
  <td height=18 class=xl157463 style='height:13.2pt'></td>
  <td class=xl157463>RAM</td>
  <td class=xl157463>128GB</td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
 </tr>
 <tr height=18 style='height:13.2pt'>
  <td height=18 class=xl157463 style='height:13.2pt'></td>
  <td class=xl157463>Number of<span style='display:none'> Cores</span></td>
  <td class=xl157463 align=right>16</td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
 </tr>
 <tr height=18 style='height:13.2pt'>
  <td height=18 class=xl157463 style='height:13.2pt'></td>
  <td colspan=8 class=xl157463>Server Conf: checkpoint_segments - 300,
  checkpoint_timeout = 15 min, checkpoint_completion_target=0.9
  synchronous_commit=off, AutoVacuum=off</td>
 </tr>
 <tr height=18 style='height:13.2pt'>
  <td height=18 class=xl157463 style='height:13.2pt'></td>
  <td class=xl157463>shared_bu<span style='display:none'>ffers</span></td>
  <td class=xl157463>32GB</td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl637463 width=72 style='width:54pt'></td>
  <td class=xl157463></td>
 </tr>
 <tr height=18 style='height:13.2pt'>
  <td height=18 class=xl157463 style='height:13.2pt'></td>
  <td class=xl157463>pgbench</td>
  <td class=xl157463 colspan=2>select-only</td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
 </tr>
 <tr height=18 style='height:13.2pt'>
  <td height=18 class=xl157463 style='height:13.2pt'></td>
  <td class=xl157463>pgbench-<span style='display:none'>Scale Factor</span></td>
  <td class=xl157463 align=right>6700</td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
 </tr>
 <tr height=18 style='height:13.2pt'>
  <td height=18 class=xl157463 style='height:13.2pt'></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
 </tr>
 <tr height=18 style='height:13.2pt'>
  <td height=18 class=xl157463 style='height:13.2pt'></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
 </tr>
 <tr height=18 style='height:13.8pt'>
  <td height=18 class=xl157463 style='height:13.8pt'></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
 </tr>
 <tr height=18 style='height:13.8pt'>
  <td height=18 class=xl157463 style='height:13.8pt'></td>
  <td class=xl637463 width=64 style='width:48pt'></td>
  <td colspan=3 class=xl767463 width=192 style='border-right:1.0pt solid black;
  width:144pt'>HEAD</td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
 </tr>
 <tr height=18 style='height:13.8pt'>
  <td height=18 class=xl157463 style='height:13.8pt'></td>
  <td class=xl637463 width=64 style='width:48pt'></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
 </tr>
 <tr height=53 style='height:39.6pt'>
  <td height=53 class=xl157463 style='height:39.6pt'></td>
  <td class=xl707463 width=64 style='width:48pt'>Runs/Concurrency</td>
  <td class=xl687463 style='border-left:none'>16C-16T</td>
  <td class=xl687463 style='border-left:none'>32C-32T</td>
  <td class=xl697463 style='border-left:none'>64C-64T</td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
 </tr>
 <tr height=18 style='height:13.2pt'>
  <td height=18 class=xl157463 style='height:13.2pt'></td>
  <td class=xl717463 width=64 style='border-top:none;width:48pt'>Run-1</td>
  <td class=xl647463 align=right style='border-top:none;border-left:none'>5354</td>
  <td class=xl647463 align=right style='border-top:none;border-left:none'>4485</td>
  <td class=xl657463 align=right style='border-top:none;border-left:none'>3607</td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
 </tr>
 <tr height=18 style='height:13.2pt'>
  <td height=18 class=xl157463 style='height:13.2pt'></td>
  <td class=xl717463 width=64 style='border-top:none;width:48pt'>Run-2</td>
  <td class=xl647463 align=right style='border-top:none;border-left:none'>4672</td>
  <td class=xl647463 align=right style='border-top:none;border-left:none'>4376</td>
  <td class=xl657463 align=right style='border-top:none;border-left:none'>3461</td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
 </tr>
 <tr height=18 style='height:13.2pt'>
  <td height=18 class=xl157463 style='height:13.2pt'></td>
  <td class=xl717463 width=64 style='border-top:none;width:48pt'>Run-3</td>
  <td class=xl647463 align=right style='border-top:none;border-left:none'>3147</td>
  <td class=xl647463 align=right style='border-top:none;border-left:none'>3052</td>
  <td class=xl657463 align=right style='border-top:none;border-left:none'>3325</td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
 </tr>
 <tr height=18 style='height:13.8pt'>
  <td height=18 class=xl157463 style='height:13.8pt'></td>
  <td class=xl727463 width=64 style='border-top:none;width:48pt'>Average</td>
  <td class=xl667463 align=right style='border-top:none;border-left:none'>4391</td>
  <td class=xl667463 align=right style='border-top:none;border-left:none'>3971</td>
  <td class=xl677463 align=right style='border-top:none;border-left:none'>3464</td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
 </tr>
 <tr height=18 style='height:13.8pt'>
  <td height=18 class=xl157463 style='height:13.8pt'></td>
  <td class=xl637463 width=64 style='width:48pt'></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
 </tr>
 <tr height=18 style='height:13.8pt'>
  <td height=18 class=xl157463 style='height:13.8pt'></td>
  <td class=xl637463 width=64 style='width:48pt'></td>
  <td colspan=3 class=xl767463 width=192 style='border-right:1.0pt solid black;
  width:144pt'>After Patch</td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
 </tr>
 <tr height=18 style='height:13.8pt'>
  <td height=18 class=xl157463 style='height:13.8pt'></td>
  <td class=xl637463 width=64 style='width:48pt'></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
 </tr>
 <tr height=53 style='height:39.6pt'>
  <td height=53 class=xl157463 style='height:39.6pt'></td>
  <td class=xl707463 width=64 style='width:48pt'>Runs/Concurrency</td>
  <td class=xl687463 style='border-left:none'>16C-16T</td>
  <td class=xl687463 style='border-left:none'>32C-32T</td>
  <td class=xl697463 style='border-left:none'>64C-64T</td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
 </tr>
 <tr height=18 style='height:13.2pt'>
  <td height=18 class=xl157463 style='height:13.2pt'></td>
  <td class=xl717463 width=64 style='border-top:none;width:48pt'>Run-1</td>
  <td class=xl647463 align=right style='border-top:none;border-left:none'>5376</td>
  <td class=xl647463 align=right style='border-top:none;border-left:none'>4449</td>
  <td class=xl657463 align=right style='border-top:none;border-left:none'>3606</td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
 </tr>
 <tr height=18 style='height:13.2pt'>
  <td height=18 class=xl157463 style='height:13.2pt'></td>
  <td class=xl717463 width=64 style='border-top:none;width:48pt'>Run-2</td>
  <td class=xl647463 align=right style='border-top:none;border-left:none'>5227</td>
  <td class=xl647463 align=right style='border-top:none;border-left:none'>4521</td>
  <td class=xl657463 align=right style='border-top:none;border-left:none'>3474</td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
 </tr>
 <tr height=18 style='height:13.2pt'>
  <td height=18 class=xl157463 style='height:13.2pt'></td>
  <td class=xl717463 width=64 style='border-top:none;width:48pt'>Run-3</td>
  <td class=xl647463 align=right style='border-top:none;border-left:none'>7838</td>
  <td class=xl647463 align=right style='border-top:none;border-left:none'>6310</td>
  <td class=xl657463 align=right style='border-top:none;border-left:none'>4753</td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
 </tr>
 <tr height=18 style='height:13.8pt'>
  <td height=18 class=xl157463 style='height:13.8pt'></td>
  <td class=xl727463 width=64 style='border-top:none;width:48pt'>Average</td>
  <td class=xl667463 align=right style='border-top:none;border-left:none'>6147</td>
  <td class=xl667463 align=right style='border-top:none;border-left:none'>5093</td>
  <td class=xl677463 align=right style='border-top:none;border-left:none'>3944</td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
 </tr>
 <tr height=18 style='height:13.2pt'>
  <td height=18 class=xl157463 style='height:13.2pt'></td>
  <td class=xl637463 width=64 style='width:48pt'></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
 </tr>
 <tr height=18 style='height:13.8pt'>
  <td height=18 class=xl157463 style='height:13.8pt'></td>
  <td class=xl637463 width=64 style='width:48pt'></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
 </tr>
 <tr height=18 style='height:13.8pt'>
  <td height=18 class=xl157463 style='height:13.8pt'></td>
  <td class=xl757463 width=64 style='width:48pt'>Diff In %</td>
  <td class=xl737463 align=right style='border-left:none'>39.99</td>
  <td class=xl737463 align=right style='border-left:none'>28.25</td>
  <td class=xl747463 align=right style='border-left:none'>13.85</td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
 </tr>
 <tr height=18 style='height:13.2pt'>
  <td height=18 class=xl157463 style='height:13.2pt'></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
 </tr>
 <tr height=18 style='height:13.2pt'>
  <td height=18 class=xl157463 style='height:13.2pt'></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
 </tr>
 <tr height=18 style='height:13.2pt'>
  <td height=18 class=xl157463 style='height:13.2pt'></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
 </tr>
 <tr height=18 style='height:13.2pt'>
  <td height=18 class=xl157463 style='height:13.2pt'></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
 </tr>
 <tr height=18 style='height:13.2pt'>
  <td height=18 class=xl157463 style='height:13.2pt'></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
 </tr>
 <tr height=18 style='height:13.8pt'>
  <td height=18 class=xl157463 style='height:13.8pt'></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
 </tr>
 <tr height=18 style='height:13.8pt'>
  <td height=18 class=xl157463 style='height:13.8pt'></td>
  <td colspan=2 class=xl767463 width=128 style='border-right:1.0pt solid black;
  width:96pt'>Configuration Used</td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
 </tr>
 <tr height=18 style='height:13.2pt'>
  <td height=18 class=xl157463 style='height:13.2pt'></td>
  <td class=xl157463>O/S</td>
  <td class=xl157463>Suse-11</td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
 </tr>
 <tr height=18 style='height:13.2pt'>
  <td height=18 class=xl157463 style='height:13.2pt'></td>
  <td class=xl157463>RAM</td>
  <td class=xl157463>24GB</td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
 </tr>
 <tr height=18 style='height:13.2pt'>
  <td height=18 class=xl157463 style='height:13.2pt'></td>
  <td class=xl157463>Number of<span style='display:none'> Cores</span></td>
  <td class=xl157463 align=right>8</td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
 </tr>
 <tr height=18 style='height:13.2pt'>
  <td height=18 class=xl157463 style='height:13.2pt'></td>
  <td colspan=8 class=xl157463>Server Conf: checkpoint_segments - 256,
  checkpoint_timeout = 25 min, synchronous_commit=off</td>
 </tr>
 <tr height=18 style='height:13.2pt'>
  <td height=18 class=xl157463 style='height:13.2pt'></td>
  <td class=xl157463>shared_bu<span style='display:none'>ffers</span></td>
  <td class=xl157463>5GB</td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl637463 width=72 style='width:54pt'></td>
  <td class=xl157463></td>
 </tr>
 <tr height=18 style='height:13.2pt'>
  <td height=18 class=xl157463 style='height:13.2pt'></td>
  <td class=xl157463>pgbench</td>
  <td class=xl157463 colspan=2>select-only</td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
 </tr>
 <tr height=18 style='height:13.2pt'>
  <td height=18 class=xl157463 style='height:13.2pt'></td>
  <td class=xl157463>pgbench-<span style='display:none'>Scale Factor</span></td>
  <td class=xl157463 align=right>1200</td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
 </tr>
 <tr height=18 style='height:13.2pt'>
  <td height=18 class=xl157463 style='height:13.2pt'></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
 </tr>
 <tr height=18 style='height:13.2pt'>
  <td height=18 class=xl157463 style='height:13.2pt'></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
 </tr>
 <tr height=18 style='height:13.8pt'>
  <td height=18 class=xl157463 style='height:13.8pt'></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
 </tr>
 <tr height=18 style='height:13.8pt'>
  <td height=18 class=xl157463 style='height:13.8pt'></td>
  <td class=xl637463 width=64 style='width:48pt'></td>
  <td colspan=3 class=xl767463 width=192 style='border-right:1.0pt solid black;
  width:144pt'>HEAD</td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
 </tr>
 <tr height=18 style='height:13.8pt'>
  <td height=18 class=xl157463 style='height:13.8pt'></td>
  <td class=xl637463 width=64 style='width:48pt'></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
 </tr>
 <tr height=53 style='height:39.6pt'>
  <td height=53 class=xl157463 style='height:39.6pt'></td>
  <td class=xl707463 width=64 style='width:48pt'>Runs/Concurrency</td>
  <td class=xl687463 style='border-left:none'>8C-8T</td>
  <td class=xl687463 style='border-left:none'>16C-16T</td>
  <td class=xl687463 style='border-left:none'>32C-32T</td>
  <td class=xl687463 style='border-left:none'>64C-64T</td>
  <td class=xl687463 style='border-left:none'>128C-128<span style='display:
  none'>T</span></td>
  <td class=xl697463 style='border-left:none'>256C-256T</td>
  <td class=xl157463></td>
 </tr>
 <tr height=18 style='height:13.2pt'>
  <td height=18 class=xl157463 style='height:13.2pt'></td>
  <td class=xl717463 width=64 style='border-top:none;width:48pt'>Run-1</td>
  <td class=xl647463 align=right style='border-top:none;border-left:none'>59034</td>
  <td class=xl647463 align=right style='border-top:none;border-left:none'>56109</td>
  <td class=xl647463 align=right style='border-top:none;border-left:none'>15374</td>
  <td class=xl647463 align=right style='border-top:none;border-left:none'>7220</td>
  <td class=xl647463 align=right style='border-top:none;border-left:none'>4441</td>
  <td class=xl657463 align=right style='border-top:none;border-left:none'>3110</td>
  <td class=xl157463></td>
 </tr>
 <tr height=18 style='height:13.2pt'>
  <td height=18 class=xl157463 style='height:13.2pt'></td>
  <td class=xl717463 width=64 style='border-top:none;width:48pt'>Run-2</td>
  <td class=xl647463 align=right style='border-top:none;border-left:none'>58604</td>
  <td class=xl647463 align=right style='border-top:none;border-left:none'>57056</td>
  <td class=xl647463 align=right style='border-top:none;border-left:none'>17698</td>
  <td class=xl647463 align=right style='border-top:none;border-left:none'>5067</td>
  <td class=xl647463 align=right style='border-top:none;border-left:none'>2621</td>
  <td class=xl657463 align=right style='border-top:none;border-left:none'>1730</td>
  <td class=xl157463></td>
 </tr>
 <tr height=18 style='height:13.2pt'>
  <td height=18 class=xl157463 style='height:13.2pt'></td>
  <td class=xl717463 width=64 style='border-top:none;width:48pt'>Run-3</td>
  <td class=xl647463 align=right style='border-top:none;border-left:none'>58874</td>
  <td class=xl647463 align=right style='border-top:none;border-left:none'>57057</td>
  <td class=xl647463 align=right style='border-top:none;border-left:none'>25098</td>
  <td class=xl647463 align=right style='border-top:none;border-left:none'>4756</td>
  <td class=xl647463 align=right style='border-top:none;border-left:none'>2511</td>
  <td class=xl657463 align=right style='border-top:none;border-left:none'>1640</td>
  <td class=xl157463></td>
 </tr>
 <tr height=18 style='height:13.8pt'>
  <td height=18 class=xl157463 style='height:13.8pt'></td>
  <td class=xl727463 width=64 style='border-top:none;width:48pt'>Average</td>
  <td class=xl667463 align=right style='border-top:none;border-left:none'>58837</td>
  <td class=xl667463 align=right style='border-top:none;border-left:none'>56740</td>
  <td class=xl667463 align=right style='border-top:none;border-left:none'>19390</td>
  <td class=xl667463 align=right style='border-top:none;border-left:none'>5681</td>
  <td class=xl667463 align=right style='border-top:none;border-left:none'>3191</td>
  <td class=xl677463 align=right style='border-top:none;border-left:none'>2160</td>
  <td class=xl157463></td>
 </tr>
 <tr height=18 style='height:13.8pt'>
  <td height=18 class=xl157463 style='height:13.8pt'></td>
  <td class=xl637463 width=64 style='width:48pt'></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
 </tr>
 <tr height=18 style='height:13.8pt'>
  <td height=18 class=xl157463 style='height:13.8pt'></td>
  <td class=xl637463 width=64 style='width:48pt'></td>
  <td colspan=3 class=xl767463 width=192 style='border-right:1.0pt solid black;
  width:144pt'>After Patch</td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
 </tr>
 <tr height=18 style='height:13.8pt'>
  <td height=18 class=xl157463 style='height:13.8pt'></td>
  <td class=xl637463 width=64 style='width:48pt'></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
 </tr>
 <tr height=53 style='height:39.6pt'>
  <td height=53 class=xl157463 style='height:39.6pt'></td>
  <td class=xl707463 width=64 style='width:48pt'>Runs/Concurrency</td>
  <td class=xl687463 style='border-left:none'>8C-8T</td>
  <td class=xl687463 style='border-left:none'>16C-16T</td>
  <td class=xl687463 style='border-left:none'>32C-32T</td>
  <td class=xl687463 style='border-left:none'>64C-64T</td>
  <td class=xl687463 style='border-left:none'>128C-128<span style='display:
  none'>T</span></td>
  <td class=xl697463 style='border-left:none'>256C-256T</td>
  <td class=xl157463></td>
 </tr>
 <tr height=18 style='height:13.2pt'>
  <td height=18 class=xl157463 style='height:13.2pt'></td>
  <td class=xl717463 width=64 style='border-top:none;width:48pt'>Run-1</td>
  <td class=xl647463 align=right style='border-top:none;border-left:none'>59285</td>
  <td class=xl647463 align=right style='border-top:none;border-left:none'>55970</td>
  <td class=xl647463 align=right style='border-top:none;border-left:none'>20894</td>
  <td class=xl647463 align=right style='border-top:none;border-left:none'>9263</td>
  <td class=xl647463 align=right style='border-top:none;border-left:none'>5655</td>
  <td class=xl657463 align=right style='border-top:none;border-left:none'>3665</td>
  <td class=xl157463></td>
 </tr>
 <tr height=18 style='height:13.2pt'>
  <td height=18 class=xl157463 style='height:13.2pt'></td>
  <td class=xl717463 width=64 style='border-top:none;width:48pt'>Run-2</td>
  <td class=xl647463 align=right style='border-top:none;border-left:none'>59521</td>
  <td class=xl647463 align=right style='border-top:none;border-left:none'>57246</td>
  <td class=xl647463 align=right style='border-top:none;border-left:none'>23380</td>
  <td class=xl647463 align=right style='border-top:none;border-left:none'>6841</td>
  <td class=xl647463 align=right style='border-top:none;border-left:none'>3770</td>
  <td class=xl657463 align=right style='border-top:none;border-left:none'>2351</td>
  <td class=xl157463></td>
 </tr>
 <tr height=18 style='height:13.2pt'>
  <td height=18 class=xl157463 style='height:13.2pt'></td>
  <td class=xl717463 width=64 style='border-top:none;width:48pt'>Run-3</td>
  <td class=xl647463 align=right style='border-top:none;border-left:none'>59642</td>
  <td class=xl647463 align=right style='border-top:none;border-left:none'>57592</td>
  <td class=xl647463 align=right style='border-top:none;border-left:none'>30937</td>
  <td class=xl647463 align=right style='border-top:none;border-left:none'>6863</td>
  <td class=xl647463 align=right style='border-top:none;border-left:none'>3074</td>
  <td class=xl657463 align=right style='border-top:none;border-left:none'>2097</td>
  <td class=xl157463></td>
 </tr>
 <tr height=18 style='height:13.8pt'>
  <td height=18 class=xl157463 style='height:13.8pt'></td>
  <td class=xl727463 width=64 style='border-top:none;width:48pt'>Average</td>
  <td class=xl667463 align=right style='border-top:none;border-left:none'>59482</td>
  <td class=xl667463 align=right style='border-top:none;border-left:none'>56936</td>
  <td class=xl667463 align=right style='border-top:none;border-left:none'>25070</td>
  <td class=xl667463 align=right style='border-top:none;border-left:none'>7655</td>
  <td class=xl667463 align=right style='border-top:none;border-left:none'>4166</td>
  <td class=xl677463 align=right style='border-top:none;border-left:none'>2704</td>
  <td class=xl157463></td>
 </tr>
 <tr height=18 style='height:13.2pt'>
  <td height=18 class=xl157463 style='height:13.2pt'></td>
  <td class=xl637463 width=64 style='width:48pt'></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
 </tr>
 <tr height=18 style='height:13.8pt'>
  <td height=18 class=xl157463 style='height:13.8pt'></td>
  <td class=xl637463 width=64 style='width:48pt'></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
  <td class=xl157463></td>
 </tr>
 <tr height=18 style='height:13.8pt'>
  <td height=18 class=xl157463 style='height:13.8pt'></td>
  <td class=xl757463 width=64 style='width:48pt'>Diff In %</td>
  <td class=xl737463 align=right style='border-left:none'>1.09</td>
  <td class=xl737463 align=right style='border-left:none'>0.35</td>
  <td class=xl737463 align=right style='border-left:none'>29.29</td>
  <td class=xl737463 align=right style='border-left:none'>34.74</td>
  <td class=xl737463 align=right style='border-left:none'>30.55</td>
  <td class=xl747463 align=right style='border-left:none'>25.18</td>
  <td class=xl157463></td>
 </tr>
 <![if supportMisalignedColumns]>
 <tr height=0 style='display:none'>
  <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=64 style='width:48pt'></td>
  <td width=72 style='width:54pt'></td>
  <td width=434 style='width:326pt'></td>
 </tr>
 <![endif]>
</table>

</div>


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

</html>=

  [application/octet-stream] load_all_buffers.sql (1.3K, ../005601ce6283$a814b410$f83e1c30$@kapila@huawei.com/4-load_all_buffers.sql)
  download

view thread (39+ messages)  latest in thread

Message-ID: <005601ce6283$a814b410$f83e1c30$@kapila@huawei.com>
Permalink:  ../005601ce6283$a814b410$f83e1c30$@kapila@huawei.com/
Also on:    postgresql.org/message-id/005601ce6283$a814b410$f83e1c30$@kapila@huawei.com

 ·  · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-hackers@postgresql.org
  Cc: amit.kapila@huawei.com, robertmhaas@gmail.com, greg@2ndquadrant.com
  Subject: Re: Move unused buffers to freelist
  In-Reply-To: <005601ce6283$a814b410$f83e1c30$@kapila@huawei.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox