Shelby Cain <alyandon(at)yahoo(dot)com> writes:
> I'm trying to keep postgresql's memory usage
> under 40 megs under all conditions so that other
> services/applications don't grind to a halt due to
> swapping. Is there any way to achieve my goal?
Don't use VACUUM FULL. The vacuum_mem setting only limits the space
consumed by plain VACUUM --- VACUUM FULL needs to keep track of all the
free space in the table, and will eat as much memory as it has to to do
that.
regards, tom lane