Re: [GENERAL] shared_buffers Question

2004-08-19 Thread Scott Marlowe
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

Re: [GENERAL] shared_buffers Question

2004-08-17 Thread Joe Lester
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

Re: [GENERAL] shared_buffers Question

2004-08-10 Thread Scott Ribe
> 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

Re: [GENERAL] shared_buffers Question

2004-08-10 Thread Scott Ribe
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