Skip site navigation (1) Skip section navigation (2)

Re: BUG #5767: Memory Leak

From: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
To: Darryl Pye <darrylpye(at)hotmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #5767: Memory Leak
Date: 2010-11-26 01:45:55
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
On 11/25/2010 12:28 PM, Darryl Pye wrote:

 > PostgreSQL version: 9.01

32-bit or 64-bit ?

> A single postgres  process  appears to be constantly growing in memory usage
>   until it reaches 100% of memory on the machine.

How are you watching it? Task manager?

You need to use something that can differentiate between the shared 
memory block and the per-task private memory. Process Explorer can do 
that, IIRC.

> 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.

Are you able to identify which postgres process it is? Is it shown in 
"SELECT * from pg_stat_activity;" ?

Is it one of the postgres processes that appears when PostgreSQL is 
first started, before any connections are made to the database server?

Are you sure you're not looking at totals for all postgres.exe instances?

> I have made the following configuration changes from default
> shared_buffers = 1GB
> wal_buffers = 1MB	
> effective_cache_size = 2GB

With those settings, you should expect PostgreSQL to appear to use a bit 
over 1GB of RAM per postgres.exe, though the vast majority of that 1GB 
should be shared between all the postgres.exe processes so the total 
memory of all postgres.exe instances will appear to vastly exceed your 
machine's RAM. That's just because of the bad accounting for shared 
memory in most OSes, including windows, and doesn't affect how it runs.

Craig Ringer

In response to

pgsql-bugs by date

Next:From: Shafqat AliDate: 2010-11-26 03:21:52
Subject: BUG #5771: C:\Program Files\PostgreSQL\8.3\Data is not accessible.
Previous:From: Bruce MomjianDate: 2010-11-25 18:11:44
Subject: Re: Re: [BUGS] BUG #5650: Postgres service showing as stopped when in fact it is running

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group