Re: postgres writer process growing up too much

["Heiner Vega" <hvegat@xxxxxxxxx>]

Thanks to you guys for your help... I appreciate it a lot.

Now, I still have my SHR and RES growing up. How can I know the number at which those values should stop?

On Dec 14, 2007 5:12 PM, Tom Lane < tgl@xxxxxxxxxxxxx> wrote:

Richard Huxton < dev@xxxxxxxxxxxx> writes:

> Heiner Vega wrote:
>> I've been monitoring my postgres processes and I noticed that the resident
>> memory
>> size of the writer process is growing up too much.

> Notice the "SHR"=shared value. That's 155MB virtual memory, 140MB of it
> resident of which 139MB is shared with other processes. So - nothing to
> worry about.

The reason the SHR number grows over time is that the system only counts
a page of shared memory against the process after the process has first
touched it.  Once the bgwriter has touched every page of shared buffers,
the number will stop changing.

If there were actually a memory leak, the VIRT number would be growing
... but it's not.

>> My postgres version is 8.1.3

If I were you, I'd be considerably more worried about the fact that
you are running an old release with a pile of known bugs.

                       regards, tom lane

-- 
Heiner Vega Thames