Re: Postgres filling up hard drive with swap files

> How many Postgres processes are running?

146 right now. Most of them are idle at any given point in time.

> Does this number increase with
> the memory usage.

No. There are 140 - 150 postgres processes running on average, but the
memory usage keeps going up and up.

> Simple fact of the matter is that you have apparently found a memory
> leak. How Mac OS X deals with swapping is (more or less) unimportant.

Wow, I sure hope not. I was really hoping to take care of the problem.

> I'm wondering, however, if you have a connection leak instead. i.e.
> is it possible that your client application is opening a whole bunch
> of connections and never closing them?

No. The clients open only one connection (and hang onto it for dear
life :-).

> You did show that you have
> a max # of connection of 200. That's pretty high, unless you've got
> a lot of RAM in that machine.

I have 512 MB of RAM in the machine. The server is performing
wonderfully. It's just that the swap files keep sprouting like weeds.

> A more accurate description of the problem would be:
> How many connections are actually open?

146 right now. That's about average.

> How much memory is actually in use by Postgres processes? (The amount
> of
> swap in use is unimportant to the Postgres folks, it's an OS thing)

This is where I could use some pointers. The following line is a top
entry for a single postgres process. Hope that helps.

PID COMMAND %CPU TIME #TH #PRTS #MREGS RPRVT RSHRD RSIZE
VSIZE
14235 postgres 0.0% 0:01.36 1 9 33 880K 16.9M 9.62M
60.0M