[nycbug-talk] Increasing memory for an application

Francisco Reyes lists at stringsutils.com
Sun Apr 23 14:55:25 EDT 2006

Bob Ippolito writes:

> kern.ipc.semmni=256
> kern.ipc.semmns=512
> kern.ipc.semmnu=256
> kern.maxdsiz="1073741824" # 1GB
> kern.dfldsiz="1073741824" # 1GB
> kern.maxssiz="134217728" # 128MB

It worked. Big thanks!!
The process sucked up 768MB.

The issue is the Bacula backup program. I does a query which returns 
millions or records at once and they don't do a limit when they query the 
postgresql database. I was basically reproducing the query using the 
postgresql client, psql. 

More information about the talk mailing list