Re: postgresql + apache under heavy load
scott.marlowe <scott.marlowe@ihs.com>
From: "scott.marlowe" <scott.marlowe@ihs.com>
To: Richard Huxton <dev@archonet.com>
Cc: Alex Madon <alex.madon@bestlinuxjobs.com>, <pgsql-general@postgresql.org>
Date: 2004-01-21T20:55:13Z
Lists: pgsql-general
On Wed, 21 Jan 2004, Richard Huxton wrote: > [I noticed you were running X and mozilla (on top of gnome?). If you don't > need them, close them - that can free up to 64MB, depending on what you're > running] Note that if you've got a 64 Meg memory video card, and X uses 4 megs of system ram, it will show, in linux, as using 68 Megs of ram. Turning off X, however, will only free up the 4 megs of system ram, not the 64 on the video card. so, it's not uncommon for folks to see a modern video card in their system, look at top, and go "geeze, X is a total memory hog" when in fact it's just that linux / top count the video memory as part of the memory allocated to X. That said, I'd at least run a less heavyweight window manager like afterstep or twm, not gnome or kde on a box like that one. > I don't think you've got a RAM shortage, I think your settings are too small > and you're running out of I/O bandwidth. If you run "vmstat 5", what does it > show - you're interested in the i/o section: blocks in (bi) and out (bo) as > well as memory. Also, look at si/so (swap in and out) to monitor swap activity. If those numbers are low, then swapping isn't an issue...