Re: Memory usage during vacuum

Shelby Cain <alyandon@yahoo.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