The following bug has been logged online:
Bug reference: 5767
Logged by: Darryl Pye
Email address: darrylpye@hotmail.com
PostgreSQL version: 9.01
Operating system: Windows Server 2008
Description: Memory Leak
Details:
A single postgres process appears to be constantly growing in memory usage
until it reaches 100% of memory on the machine.
I have rebooted the server and the problem goes away but then a single
postgres.exe process continues to eat memory until it uses all available
ram then i have to restart again.
Machine has 4 gig of ram available.
I am able to watch the process grow constantly at approximately 8kb every
second.
Until it reaches 4gig.
I have made the following configuration changes from default
shared_buffers = 1GB
wal_buffers = 1MB
effective_cache_size = 2GB