[rt-users] Excessive communication between RT and postgresql

[Jacobsson, Henrik G]

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.

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.

The pattern of volume of WAL produced closely match up to the graph of network traffic between the RT server and the database server.

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.

Any clues on what this might be caused by?

We are running
RT 4.2.1 and Apache 2.2.15 on CentOS 6.4
Postgresql 9.3 on CentOS 5.10

Kind regards
//Henrik

--------------------------------------------------------------------------
Confidentiality Notice: 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.
 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20131216/58f901a6/attachment.htm>