Hi Tom,
I'll try to be more specific, but top doesn't report anything unusual. Each connection (28 of them) has around 1 MB RPRVT, 101 MB real shared, between 10 and 50 MB Real Size, and 231 MB Virtual Size. These values haven't changed. The postmaster has 60k Real private, 101MB Real shared, 756 k real size and 230 MB in Virtual Size.
shared buffers is at shared_buffers = 12500 (100 MB) sort_mem = 5000 vacuum_mem = 5000
My problem is that I can't pinpoint a process that is constantly paging out. So any pointers to tools to investigate the problem more would be very helpful. Any unusual things to look for when running lsof? Nothing special in the postgres server log. Settings for shared memory in /etc/rc: sysctl -w kern.sysv.shmmax=268435456 sysctl -w kern.sysv.shmmin=1 sysctl -w kern.sysv.shmmni=32 sysctl -w kern.sysv.shmseg=8 sysctl -w kern.sysv.shmall=65536
The only thing that strikes me as odd, is that each connection has such a large
virtual size, our backup system is running with shared_buffers of 10 MB
and shows only around 30 MB Virtual size.
Basic problem that the system is paging out and allocating more and more place
on the disc persists (9 GB, right now and has been up for 3 days).
Maybe I'll try to lower shared buffers...
Christian
P.S.: Running 7.4.2 on OSX 10.3.4 with 4.5 GB RAM.
On Jun 8, 2004, at 6:53 AM, Tom Lane wrote:
Christian van der leeden <[EMAIL PROTECTED]> writes:this is just a me too message.
Neither one of you has provided any information that would let anyone else even guess where to look for the problem :-(
For starters, which process or processes is eating memory? (see top(1))
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
----------------------------------------------- Christian van der Leeden Software Engineering
BEGIN:VCARD VERSION:3.0 N:van der Leeden;Christian;;; FN:Christian van der Leeden ORG:Logic United GmbH; TITLE:Software Engineering EMAIL;type=INTERNET;type=HOME;type=pref:[EMAIL PROTECTED] EMAIL;type=INTERNET;type=WORK:[EMAIL PROTECTED] TEL;type=WORK;type=pref:+49-89-189488-66 TEL;type=CELL:+49-163-3747111 item1.ADR;type=WORK;type=pref:;;Brecherspitzstrasse 8;Muenchen;;81541;Germany item1.X-ABADR:de URL:www.logicunited.com X-AIM;type=HOME;type=pref:next2you X-ICQ;type=WORK;type=pref:13450543 CATEGORY:Buddy,EADS END:VCARD
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
