Is the memory freed up if you shut down and restart PostgreSQL? If not,
then it might not be PostgreSQL that's directly causing the issue, but
something like logging. What OS is this by the way?
On Tue, 2004-08-17 at 15:10, Joe Lester wrote:
> Thanks for the suggestion Scott. I did a...
>
> fin
Thanks for the suggestion Scott. I did a...
find / -type f -size +10 -print
The results contained 9 Gig! of swap files:
/private/var/vm/swapfile0
/private/var/vm/swapfile1
/private/var/vm/swapfile10
[plus many more entries]
That seems to indicate to me a memory "leak" of some sort. My s
> Your shared buffers are almost certainly not the problem here. 2000
> shared buffers is only 16 Megs of ram, max. More than likely, the
> database filled up the data directory / partition because it wasn't
> being vacuumed.
Yes.
Also check to make sure that some rogue process somewhere isn't f
BTW Joe,
I sent my earlier suggestion to you directly. You might want to talk to your
email admin to find out why your server bounced a perfectly innocuous
message thusly:
<[EMAIL PROTECTED]>:
12.47.0.10 failed after I sent the message.
Remote host said: 550 Message Returned: For some reason, you