PostgreSQL v9.3.4 memory usage Issue on Windows Server 2008 R2

This problem was solved. It was related to couple of the drivers installed on machine; PostgreSQL had nothing to do with that.

To ready more info about this issue: link.

It was caused by aksdf.sys and hardlock.sys driver files which was installed by Advantage Database Server v7.1 (we never used it though).

Our suspicion went towards PostgreSQL at first because that was the only program which was getting used on that server. So for every PostgreSQL connection, we had a Zombie process consuming 20Kb of physical memory. Hence this continued until whole physical memory was consumed and then after that we had to reboot the machine to make it work.

We used following tools to track this issue:

• RAMMAP (Most helpful)
• PROCESS EXPLORER
• TCPView