Re: [GENERAL] postgres writer process growing up too much

2007-12-17 Thread Heiner Vega
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 <[EMAIL PROTECTED]> wrote: > Richard Huxton <[EMAIL PROTECTED]> writes: > > Heiner Vega wrote: >

Re: [GENERAL] postgres writer process growing up too much

2007-12-14 Thread Tom Lane
Richard Huxton <[EMAIL PROTECTED]> 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 whi

Re: [GENERAL] postgres writer process growing up too much

2007-12-14 Thread Richard Huxton
Heiner Vega wrote: Hi to everyone I've been monitoring my postgres processes and I noticed that the resident memory size of the writer process is growing up too much. YESTERDAY: PID USER PR NI VIRT RES SHR S %CPU %MEMTIME+ COMMAND 11419 postgres 15 0 155m 112m 112m