| From: | Jonathan Vanasco <postgres(at)2xlp(dot)com> | 
|---|---|
| To: | pgsql-general(at)postgresql(dot)org | 
| Subject: | memory issues when running with mod_perl | 
| Date: | 2006-09-27 21:03:15 | 
| Message-ID: | A1F84690-20BC-40B3-85C8-02D1A4BBB278@2xlp.com | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-general | 
Someone posted an issue to the mod-perl list a few weeks ago about  
their machine losing a ton of memory under a mod-perl2/apache/ 
postgres system - and only being able to reclaim it from reboots
A few weeks later I ran into some memory related problems, and  
noticed a similar issue.  Starting / stopping the clients had no  
effect on memory  (which was expected... the new ones just pulled in  
from the shared cache )
But stopping the daemon didn't affect memory either.  running ipcs, i  
saw the shared memory lock freed.  but the kernel never seemed to get  
it back.  and then I'd run into swap.
I felt this on freebsd 6.x + pg 8.1.x , seperate people on the list  
had it under the 2.4 / 2.6 kernels  with 7.x and 8.x pgs.
someone just posted that they have the same issue on one machine  
under  7.4.9, but not (yet) under 7.4.13
does anyone have some suggestions on how to test this to make sure  
its a pg issue ?  it often takes a few days for pg to consume enough  
memory for this behavior to set in place.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bill Moran | 2006-09-27 21:10:58 | Re: cyclical redundancy checksum algorithm(s)? | 
| Previous Message | Karen Hill | 2006-09-27 21:02:51 | Re: cyclical redundancy checksum algorithm(s)? |