[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    how to reduce Xidgenlock wait event
From:       Ishan Joshi <Ishan.Joshi () amdocs ! com>
Date:       2021-08-24 10:08:33
Message-ID: VE1PR06MB7119E200A63CB76E96D12C8786C59 () VE1PR06MB7119 ! eurprd06 ! prod ! outlook ! com
[Download RAW message or body]

Hi Team,

We have been observing XidGenlock wait in our transaction. This leeads some=
 perofmrance issue in our product. We have heavyly commit product but still=
 we are not getting such wait during the time. We have increase our load to=
 double and then it start getting it. I have check the transaction id is no=
t getting reached to the max size.

I am using AWS RDS instance and we have autovacuum on on this RDS. Plese fi=
nd  parameter as follows.
Please let me know who to reduce such wait event with tunning of some param=
eters.

autovacuum
on
  autovacuum_analyze_scale_factor
0
  autovacuum_analyze_threshold
1000
  autovacuum_freeze_max_age
200000000
  autovacuum_max_workers
20
  autovacuum_multixact_freeze_max_age
10000000
  autovacuum_naptime
10
  autovacuum_vacuum_cost_delay
0
  autovacuum_vacuum_cost_limit
-1
  autovacuum_vacuum_scale_factor
0.1
  autovacuum_vacuum_threshold
1000
  checkpoint_completion_target
0.9
  cpu_tuple_cost
0.03
  effective_cache_size
23592960 (180 GB)
  seq_page_cost
0.7
  shared_buffers
64GB
  temp_buffers
16384
  vacuum_cost_delay
0
  vacuum_cost_limit
6000
  vacuum_cost_page_dirty
20
  vacuum_cost_page_miss
5
  vacuum_defer_cleanup_age
0
  vacuum_freeze_min_age
10000
  vacuum_freeze_table_age
20000
  vacuum_multixact_freeze_min_age
10000
  vacuum_multixact_freeze_table_age
20000
  wal_buffers
262143
  wal_keep_segments
400
  work_mem
18432


Thanks & Regards
Ishan Joshi

This email and the information contained herein is proprietary and confiden=
tial and subject to the Amdocs Email Terms of Service, which you may review=
 at https://www.amdocs.com/about/email-terms-of-service <https://www.amdocs=
.com/about/email-terms-of-service>

[Attachment #3 (text/html)]

<html xmlns:v="urn:schemas-microsoft-com:vml" \
xmlns:o="urn:schemas-microsoft-com:office:office" \
xmlns:w="urn:schemas-microsoft-com:office:word" \
xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" \
xmlns="http://www.w3.org/TR/REC-html40"> <head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
	{font-family:"Cambria Math";
	panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
	{font-family:Calibri;
	panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0in;
	font-size:11.0pt;
	font-family:"Calibri",sans-serif;}
.MsoChpDefault
	{mso-style-type:export-only;
	font-size:10.0pt;}
@page WordSection1
	{size:8.5in 11.0in;
	margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
	{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="#0563C1" vlink="#954F72" style="word-wrap:break-word">
<div class="WordSection1">
<p class="MsoNormal"><span style="color:#2F5496">Hi Team,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#2F5496"><o:p>&nbsp;</o:p></span></p>
<p class="MsoNormal"><span style="color:#2F5496">We have been observing XidGenlock \
wait in our transaction. This leeads some perofmrance issue in our product. We have \
heavyly commit product but still we are not getting such wait during the time. We \
have increase  our load to double and then it start getting it. I have check the \
transaction id is not getting reached to the max size.<o:p></o:p></span></p> <p \
class="MsoNormal"><span style="color:#2F5496"><o:p>&nbsp;</o:p></span></p> <p \
class="MsoNormal"><span style="color:#2F5496">I am using AWS RDS instance and we have \
autovacuum on on this RDS. Plese find&nbsp; parameter as follows. \
<o:p></o:p></span></p> <p class="MsoNormal"><span style="color:#2F5496">Please let me \
know who to reduce such wait event with tunning of some \
parameters.<o:p></o:p></span></p> <p class="MsoNormal"><span \
style="color:#2F5496"><o:p>&nbsp;</o:p></span></p> <table class="MsoNormalTable" \
border="0" cellspacing="0" cellpadding="0" width="416" \
style="width:312.0pt;margin-left:-.05pt;border-collapse:collapse"> <tbody>
<tr style="height:.2in">
<td width="273" nowrap="" valign="top" style="width:205.0pt;border:solid windowtext \
1.0pt;padding:0in 5.4pt 0in 5.4pt;height:.2in"> <p class="MsoNormal"><span \
style="color:black">autovacuum<o:p></o:p></span></p> </td>
<td width="143" nowrap="" valign="top" style="width:107.0pt;border:solid windowtext \
1.0pt;border-left:none;padding:0in 5.4pt 0in 5.4pt;height:.2in"> <p \
class="MsoNormal"><span style="color:black">on<o:p></o:p></span></p> </td>
</tr>
<tr style="height:.2in">
<td width="273" nowrap="" valign="top" style="width:205.0pt;border:solid windowtext \
1.0pt;border-top:none;padding:0in 5.4pt 0in 5.4pt;height:.2in"> <p \
class="MsoNormal"><span style="color:black">&nbsp; \
autovacuum_analyze_scale_factor&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; \
<o:p></o:p></span></p> </td>
<td width="143" nowrap="" valign="top" \
style="width:107.0pt;border-top:none;border-left:none;border-bottom:solid windowtext \
1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:.2in"> \
<p class="MsoNormal"><span style="color:black">0<o:p></o:p></span></p> </td>
</tr>
<tr style="height:.2in">
<td width="273" nowrap="" valign="top" style="width:205.0pt;border:solid windowtext \
1.0pt;border-top:none;padding:0in 5.4pt 0in 5.4pt;height:.2in"> <p \
class="MsoNormal"><span style="color:black">&nbsp; \
autovacuum_analyze_threshold&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
 <o:p></o:p></span></p>
</td>
<td width="143" nowrap="" valign="top" \
style="width:107.0pt;border-top:none;border-left:none;border-bottom:solid windowtext \
1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:.2in"> \
<p class="MsoNormal"><span style="color:black">1000<o:p></o:p></span></p> </td>
</tr>
<tr style="height:.2in">
<td width="273" nowrap="" valign="top" style="width:205.0pt;border:solid windowtext \
1.0pt;border-top:none;padding:0in 5.4pt 0in 5.4pt;height:.2in"> <p \
class="MsoNormal"><span style="color:black">&nbsp; \
autovacuum_freeze_max_age&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
 <o:p></o:p></span></p>
</td>
<td width="143" nowrap="" valign="top" \
style="width:107.0pt;border-top:none;border-left:none;border-bottom:solid windowtext \
1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:.2in"> \
<p class="MsoNormal"><span style="color:black">200000000<o:p></o:p></span></p> </td>
</tr>
<tr style="height:.2in">
<td width="273" nowrap="" valign="top" style="width:205.0pt;border:solid windowtext \
1.0pt;border-top:none;padding:0in 5.4pt 0in 5.4pt;height:.2in"> <p \
class="MsoNormal"><span style="color:black">&nbsp; \
autovacuum_max_workers&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
 <o:p></o:p></span></p>
</td>
<td width="143" nowrap="" valign="top" \
style="width:107.0pt;border-top:none;border-left:none;border-bottom:solid windowtext \
1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:.2in"> \
<p class="MsoNormal"><span style="color:black">20<o:p></o:p></span></p> </td>
</tr>
<tr style="height:.2in">
<td width="273" nowrap="" valign="top" style="width:205.0pt;border:solid windowtext \
1.0pt;border-top:none;padding:0in 5.4pt 0in 5.4pt;height:.2in"> <p \
class="MsoNormal"><span style="color:black">&nbsp; \
autovacuum_multixact_freeze_max_age&nbsp;&nbsp;&nbsp;&nbsp; <o:p></o:p></span></p>
</td>
<td width="143" nowrap="" valign="top" \
style="width:107.0pt;border-top:none;border-left:none;border-bottom:solid windowtext \
1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:.2in"> \
<p class="MsoNormal"><span style="color:black">10000000<o:p></o:p></span></p> </td>
</tr>
<tr style="height:.2in">
<td width="273" nowrap="" valign="top" style="width:205.0pt;border:solid windowtext \
1.0pt;border-top:none;padding:0in 5.4pt 0in 5.4pt;height:.2in"> <p \
class="MsoNormal"><span style="color:black">&nbsp; \
autovacuum_naptime&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
 <o:p></o:p></span></p>
</td>
<td width="143" nowrap="" valign="top" \
style="width:107.0pt;border-top:none;border-left:none;border-bottom:solid windowtext \
1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:.2in"> \
<p class="MsoNormal"><span style="color:black">10<o:p></o:p></span></p> </td>
</tr>
<tr style="height:.2in">
<td width="273" nowrap="" valign="top" style="width:205.0pt;border:solid windowtext \
1.0pt;border-top:none;padding:0in 5.4pt 0in 5.4pt;height:.2in"> <p \
class="MsoNormal"><span style="color:black">&nbsp; \
autovacuum_vacuum_cost_delay&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
 <o:p></o:p></span></p>
</td>
<td width="143" nowrap="" valign="top" \
style="width:107.0pt;border-top:none;border-left:none;border-bottom:solid windowtext \
1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:.2in"> \
<p class="MsoNormal"><span style="color:black">0<o:p></o:p></span></p> </td>
</tr>
<tr style="height:.2in">
<td width="273" nowrap="" valign="top" style="width:205.0pt;border:solid windowtext \
1.0pt;border-top:none;padding:0in 5.4pt 0in 5.4pt;height:.2in"> <p \
class="MsoNormal"><span style="color:black">&nbsp; \
autovacuum_vacuum_cost_limit&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
 <o:p></o:p></span></p>
</td>
<td width="143" nowrap="" valign="top" \
style="width:107.0pt;border-top:none;border-left:none;border-bottom:solid windowtext \
1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:.2in"> \
<p class="MsoNormal"><span style="color:black">-1<o:p></o:p></span></p> </td>
</tr>
<tr style="height:.2in">
<td width="273" nowrap="" valign="top" style="width:205.0pt;border:solid windowtext \
1.0pt;border-top:none;padding:0in 5.4pt 0in 5.4pt;height:.2in"> <p \
class="MsoNormal"><span style="color:black">&nbsp; \
autovacuum_vacuum_scale_factor&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; \
<o:p></o:p></span></p> </td>
<td width="143" nowrap="" valign="top" \
style="width:107.0pt;border-top:none;border-left:none;border-bottom:solid windowtext \
1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:.2in"> \
<p class="MsoNormal"><span style="color:black">0.1<o:p></o:p></span></p> </td>
</tr>
<tr style="height:.2in">
<td width="273" nowrap="" valign="top" style="width:205.0pt;border:solid windowtext \
1.0pt;border-top:none;padding:0in 5.4pt 0in 5.4pt;height:.2in"> <p \
class="MsoNormal"><span style="color:black">&nbsp; \
autovacuum_vacuum_threshold&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
 <o:p></o:p></span></p>
</td>
<td width="143" nowrap="" valign="top" \
style="width:107.0pt;border-top:none;border-left:none;border-bottom:solid windowtext \
1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:.2in"> \
<p class="MsoNormal"><span style="color:black">1000<o:p></o:p></span></p> </td>
</tr>
<tr style="height:.2in">
<td width="273" nowrap="" valign="top" style="width:205.0pt;border:solid windowtext \
1.0pt;border-top:none;padding:0in 5.4pt 0in 5.4pt;height:.2in"> <p \
class="MsoNormal"><span style="color:black">&nbsp; \
checkpoint_completion_target&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
 <o:p></o:p></span></p>
</td>
<td width="143" nowrap="" valign="top" \
style="width:107.0pt;border-top:none;border-left:none;border-bottom:solid windowtext \
1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:.2in"> \
<p class="MsoNormal"><span style="color:black">0.9<o:p></o:p></span></p> </td>
</tr>
<tr style="height:.2in">
<td width="273" nowrap="" valign="top" style="width:205.0pt;border:solid windowtext \
1.0pt;border-top:none;padding:0in 5.4pt 0in 5.4pt;height:.2in"> <p \
class="MsoNormal"><span style="color:black">&nbsp; \
cpu_tuple_cost&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
 <o:p></o:p></span></p>
</td>
<td width="143" nowrap="" valign="top" \
style="width:107.0pt;border-top:none;border-left:none;border-bottom:solid windowtext \
1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:.2in"> \
<p class="MsoNormal"><span style="color:black">0.03<o:p></o:p></span></p> </td>
</tr>
<tr style="height:.2in">
<td width="273" nowrap="" valign="top" style="width:205.0pt;border:solid windowtext \
1.0pt;border-top:none;padding:0in 5.4pt 0in 5.4pt;height:.2in"> <p \
class="MsoNormal"><span style="color:black">&nbsp; \
effective_cache_size&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
 <o:p></o:p></span></p>
</td>
<td width="143" nowrap="" valign="top" \
style="width:107.0pt;border-top:none;border-left:none;border-bottom:solid windowtext \
1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:.2in"> \
<p class="MsoNormal"><span style="color:black">23592960 (180 \
GB)<o:p></o:p></span></p> </td>
</tr>
<tr style="height:.2in">
<td width="273" nowrap="" valign="top" style="width:205.0pt;border:solid windowtext \
1.0pt;border-top:none;padding:0in 5.4pt 0in 5.4pt;height:.2in"> <p \
class="MsoNormal"><span style="color:black">&nbsp; \
seq_page_cost&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;& \
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; \
<o:p></o:p></span></p> </td>
<td width="143" nowrap="" valign="top" \
style="width:107.0pt;border-top:none;border-left:none;border-bottom:solid windowtext \
1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:.2in"> \
<p class="MsoNormal"><span style="color:black">0.7<o:p></o:p></span></p> </td>
</tr>
<tr style="height:.2in">
<td width="273" nowrap="" valign="top" style="width:205.0pt;border:solid windowtext \
1.0pt;border-top:none;padding:0in 5.4pt 0in 5.4pt;height:.2in"> <p \
class="MsoNormal"><span style="color:black">&nbsp; \
shared_buffers&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
 <o:p></o:p></span></p>
</td>
<td width="143" nowrap="" valign="top" \
style="width:107.0pt;border-top:none;border-left:none;border-bottom:solid windowtext \
1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:.2in"> \
<p class="MsoNormal"><span style="color:black">64GB<o:p></o:p></span></p> </td>
</tr>
<tr style="height:.2in">
<td width="273" nowrap="" valign="top" style="width:205.0pt;border:solid windowtext \
1.0pt;border-top:none;padding:0in 5.4pt 0in 5.4pt;height:.2in"> <p \
class="MsoNormal"><span style="color:black">&nbsp; \
temp_buffers&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n \
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
 <o:p></o:p></span></p>
</td>
<td width="143" nowrap="" valign="top" \
style="width:107.0pt;border-top:none;border-left:none;border-bottom:solid windowtext \
1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:.2in"> \
<p class="MsoNormal"><span style="color:black">16384<o:p></o:p></span></p> </td>
</tr>
<tr style="height:.2in">
<td width="273" nowrap="" valign="top" style="width:205.0pt;border:solid windowtext \
1.0pt;border-top:none;padding:0in 5.4pt 0in 5.4pt;height:.2in"> <p \
class="MsoNormal"><span style="color:black">&nbsp; \
vacuum_cost_delay&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
 <o:p></o:p></span></p>
</td>
<td width="143" nowrap="" valign="top" \
style="width:107.0pt;border-top:none;border-left:none;border-bottom:solid windowtext \
1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:.2in"> \
<p class="MsoNormal"><span style="color:black">0<o:p></o:p></span></p> </td>
</tr>
<tr style="height:.2in">
<td width="273" nowrap="" valign="top" style="width:205.0pt;border:solid windowtext \
1.0pt;border-top:none;padding:0in 5.4pt 0in 5.4pt;height:.2in"> <p \
class="MsoNormal"><span style="color:black">&nbsp; \
vacuum_cost_limit&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
 <o:p></o:p></span></p>
</td>
<td width="143" nowrap="" valign="top" \
style="width:107.0pt;border-top:none;border-left:none;border-bottom:solid windowtext \
1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:.2in"> \
<p class="MsoNormal"><span style="color:black">6000<o:p></o:p></span></p> </td>
</tr>
<tr style="height:.2in">
<td width="273" nowrap="" valign="top" style="width:205.0pt;border:solid windowtext \
1.0pt;border-top:none;padding:0in 5.4pt 0in 5.4pt;height:.2in"> <p \
class="MsoNormal"><span style="color:black">&nbsp; \
vacuum_cost_page_dirty&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
 <o:p></o:p></span></p>
</td>
<td width="143" nowrap="" valign="top" \
style="width:107.0pt;border-top:none;border-left:none;border-bottom:solid windowtext \
1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:.2in"> \
<p class="MsoNormal"><span style="color:black">20<o:p></o:p></span></p> </td>
</tr>
<tr style="height:.2in">
<td width="273" nowrap="" valign="top" style="width:205.0pt;border:solid windowtext \
1.0pt;border-top:none;padding:0in 5.4pt 0in 5.4pt;height:.2in"> <p \
class="MsoNormal"><span style="color:black">&nbsp; \
vacuum_cost_page_miss&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
 <o:p></o:p></span></p>
</td>
<td width="143" nowrap="" valign="top" \
style="width:107.0pt;border-top:none;border-left:none;border-bottom:solid windowtext \
1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:.2in"> \
<p class="MsoNormal"><span style="color:black">5<o:p></o:p></span></p> </td>
</tr>
<tr style="height:.2in">
<td width="273" nowrap="" valign="top" style="width:205.0pt;border:solid windowtext \
1.0pt;border-top:none;padding:0in 5.4pt 0in 5.4pt;height:.2in"> <p \
class="MsoNormal"><span style="color:black">&nbsp; \
vacuum_defer_cleanup_age&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
 <o:p></o:p></span></p>
</td>
<td width="143" nowrap="" valign="top" \
style="width:107.0pt;border-top:none;border-left:none;border-bottom:solid windowtext \
1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:.2in"> \
<p class="MsoNormal"><span style="color:black">0<o:p></o:p></span></p> </td>
</tr>
<tr style="height:.2in">
<td width="273" nowrap="" valign="top" style="width:205.0pt;border:solid windowtext \
1.0pt;border-top:none;padding:0in 5.4pt 0in 5.4pt;height:.2in"> <p \
class="MsoNormal"><span style="color:black">&nbsp; \
vacuum_freeze_min_age&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
 <o:p></o:p></span></p>
</td>
<td width="143" nowrap="" valign="top" \
style="width:107.0pt;border-top:none;border-left:none;border-bottom:solid windowtext \
1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:.2in"> \
<p class="MsoNormal"><span style="color:black">10000<o:p></o:p></span></p> </td>
</tr>
<tr style="height:.2in">
<td width="273" nowrap="" valign="top" style="width:205.0pt;border:solid windowtext \
1.0pt;border-top:none;padding:0in 5.4pt 0in 5.4pt;height:.2in"> <p \
class="MsoNormal"><span style="color:black">&nbsp; \
vacuum_freeze_table_age&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
 <o:p></o:p></span></p>
</td>
<td width="143" nowrap="" valign="top" \
style="width:107.0pt;border-top:none;border-left:none;border-bottom:solid windowtext \
1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:.2in"> \
<p class="MsoNormal"><span style="color:black">20000<o:p></o:p></span></p> </td>
</tr>
<tr style="height:.2in">
<td width="273" nowrap="" valign="top" style="width:205.0pt;border:solid windowtext \
1.0pt;border-top:none;padding:0in 5.4pt 0in 5.4pt;height:.2in"> <p \
class="MsoNormal"><span style="color:black">&nbsp; \
vacuum_multixact_freeze_min_age&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; \
<o:p></o:p></span></p> </td>
<td width="143" nowrap="" valign="top" \
style="width:107.0pt;border-top:none;border-left:none;border-bottom:solid windowtext \
1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:.2in"> \
<p class="MsoNormal"><span style="color:black">10000<o:p></o:p></span></p> </td>
</tr>
<tr style="height:.2in">
<td width="273" nowrap="" valign="top" style="width:205.0pt;border:solid windowtext \
1.0pt;border-top:none;padding:0in 5.4pt 0in 5.4pt;height:.2in"> <p \
class="MsoNormal"><span style="color:black">&nbsp; \
vacuum_multixact_freeze_table_age&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; \
<o:p></o:p></span></p> </td>
<td width="143" nowrap="" valign="top" \
style="width:107.0pt;border-top:none;border-left:none;border-bottom:solid windowtext \
1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:.2in"> \
<p class="MsoNormal"><span style="color:black">20000<o:p></o:p></span></p> </td>
</tr>
<tr style="height:.2in">
<td width="273" nowrap="" valign="top" style="width:205.0pt;border:solid windowtext \
1.0pt;border-top:none;padding:0in 5.4pt 0in 5.4pt;height:.2in"> <p \
class="MsoNormal"><span style="color:black">&nbsp; \
wal_buffers&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb \
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
 <o:p></o:p></span></p>
</td>
<td width="143" nowrap="" valign="top" \
style="width:107.0pt;border-top:none;border-left:none;border-bottom:solid windowtext \
1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:.2in"> \
<p class="MsoNormal"><span style="color:black">262143<o:p></o:p></span></p> </td>
</tr>
<tr style="height:.2in">
<td width="273" nowrap="" valign="top" style="width:205.0pt;border:solid windowtext \
1.0pt;border-top:none;padding:0in 5.4pt 0in 5.4pt;height:.2in"> <p \
class="MsoNormal"><span style="color:black">&nbsp; \
wal_keep_segments&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
 <o:p></o:p></span></p>
</td>
<td width="143" nowrap="" valign="top" \
style="width:107.0pt;border-top:none;border-left:none;border-bottom:solid windowtext \
1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:.2in"> \
<p class="MsoNormal"><span style="color:black">400<o:p></o:p></span></p> </td>
</tr>
<tr style="height:.2in">
<td width="273" nowrap="" valign="top" style="width:205.0pt;border:solid windowtext \
1.0pt;border-top:none;padding:0in 5.4pt 0in 5.4pt;height:.2in"> <p \
class="MsoNormal"><span style="color:black">&nbsp; \
work_mem&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; \
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
 <o:p></o:p></span></p>
</td>
<td width="143" nowrap="" valign="top" \
style="width:107.0pt;border-top:none;border-left:none;border-bottom:solid windowtext \
1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:.2in"> \
<p class="MsoNormal"><span style="color:black">18432<o:p></o:p></span></p> </td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><span style="color:#2F5496"><o:p>&nbsp;</o:p></span></p>
<p class="MsoNormal"><o:p>&nbsp;</o:p></p>
<p class="MsoNormal"><span style="color:#2F5496">Thanks &amp; \
Regards<o:p></o:p></span></p> <p class="MsoNormal"><span style="color:#2F5496">Ishan \
Joshi<o:p></o:p></span></p> <p class="MsoNormal"><o:p>&nbsp;</o:p></p>
</div>
<p class="MsoNormal"><span style="FONT-SIZE: 11pt"><strong><span style="font-family: \
Calibri;">This email and the information contained herein is proprietary and \
confidential and subject to the Amdocs Email Terms of Service, which you may review \
at</span></strong><span style="font-family: Calibri;"> </span><a \
href="https://www.amdocs.com/about/email-terms-of-service"><strong><span \
style="font-family: Calibri;">https://www.amdocs.com/about/email-terms-of-service</span></strong></a></span></p></body>
 </html>



[prev in list] [next in list] [prev in thread] [next in thread] 

Configure | About | News | Add a list | Sponsored by KoreLogic