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]> <![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
copy link · copy postgr.es · copy git am
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