<HTML xmlns="http://www.w3.org/TR/REC-html40" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:v="urn:schemas-microsoft-com:vml" xmlns:w="urn:schemas-microsoft-com:office:word"><head><META content="text/html; charset=utf-8" http-equiv="Content-Type">
<STYLE><!-- /* Style Definitions */ p.74f3b770-cebc-4afb-9256-6bac6594089a, li.74f3b770-cebc-4afb-9256-6bac6594089a, div.74f3b770-cebc-4afb-9256-6bac6594089a, table.74f3b770-cebc-4afb-9256-6bac6594089aTable {margin:0cm; margin-bottom:.0001pt;}div.Section1 {page:Section1;}--></STYLE>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
<meta content="Microsoft Word 12 (filtered medium)" name="Generator">
<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:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 70.85pt 70.85pt;}
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>
<P CLASS="74f3b770-cebc-4afb-9256-6bac6594089a">
<div class="WordSection1">
<p class="MsoNormal"><span lang="EN-US">After upgrading to RT 4.2.1, the postgresql database is producing massive volumes of WAL files around the clock with peaks during office hours.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Before the upgrade – we had very limited volumes of WAL files produced, and nothing at all during non work hours. Now – at least 32MB, but usually 64MB of WAL is written every minute, when the system is supposed to be
quiet.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">The pattern of volume of WAL produced closely match up to the graph of network traffic between the RT server and the database server.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Should there be any traffic at all between the RT server and database server when the system is not in use? Apart from occasional handshakes etc.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Any clues on what this might be caused by?<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">We are running<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">RT 4.2.1 and Apache 2.2.15 on CentOS 6.4 <o:p>
</o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Postgresql 9.3 on CentOS 5.10<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Kind regards<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">//Henrik <o:p></o:p></span></p>
</div>
</P>
<P CLASS="74f3b770-cebc-4afb-9256-6bac6594089a"></P>
<P CLASS="74f3b770-cebc-4afb-9256-6bac6594089a">
<HR>
<P CLASS="74f3b770-cebc-4afb-9256-6bac6594089a" STYLE="FONT-SIZE: 8pt"><FONT FACE="Arial" SIZE="1"></FONT></P>
<P CLASS="74f3b770-cebc-4afb-9256-6bac6594089a" STYLE="FONT-SIZE: 8pt"><FONT FACE="Arial"><STRONG>Confidentiality Notice: </STRONG>This message is private and may contain confidential and proprietary information. If you have received this message in error, please notify us and remove it from your system and note that you must not copy, distribute or take any action in reliance on it. Any unauthorized use or disclosure of the contents of this message is not permitted and may be unlawful.</FONT></P>
<P CLASS="74f3b770-cebc-4afb-9256-6bac6594089a" STYLE="FONT-SIZE: 8pt"><FONT FACE="Arial"></FONT> </P>
<P CLASS="74f3b770-cebc-4afb-9256-6bac6594089a" STYLE="FONT-SIZE: 8pt"><FONT FACE="Arial"></FONT></P>
<P CLASS="74f3b770-cebc-4afb-9256-6bac6594089a" STYLE="FONT-SIZE: 8pt"><FONT FACE="Arial"></FONT></P>
<P CLASS="74f3b770-cebc-4afb-9256-6bac6594089a" STYLE="FONT-SIZE: 8pt"><FONT FACE="Arial"></FONT></P>
<P CLASS="74f3b770-cebc-4afb-9256-6bac6594089a" STYLE="FONT-SIZE: 8pt"><FONT FACE="Arial"></FONT></P>
<P CLASS="74f3b770-cebc-4afb-9256-6bac6594089a" STYLE="FONT-SIZE: 8pt"><FONT FACE="Arial"></FONT><FONT SIZE="+0"></FONT></P>
<P CLASS="74f3b770-cebc-4afb-9256-6bac6594089a" STYLE="FONT-SIZE: 8pt"><FONT FACE="Arial"></FONT></P>
<P CLASS="74f3b770-cebc-4afb-9256-6bac6594089a" STYLE="FONT-SIZE: 8pt"></P>
<P CLASS="74f3b770-cebc-4afb-9256-6bac6594089a" STYLE="FONT-SIZE: 8pt"></P>
<P CLASS="74f3b770-cebc-4afb-9256-6bac6594089a" STYLE="FONT-SIZE: 8pt"></P>
<P></P>
<P></P></P>
<P></P>
<P CLASS="74f3b770-cebc-4afb-9256-6bac6594089a" STYLE="FONT-SIZE: 8pt"></P>
<P CLASS="74f3b770-cebc-4afb-9256-6bac6594089a" STYLE="FONT-SIZE: 8pt"></P></BODY></HTML>