[nycbug-talk] Increasing memory for an application

[Francisco Reyes]

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.