Re: VACUUM FULL out of memory

Tom Lane wrote:

Michael Akinde <michael.akinde@met.no> writes: 

$> ulimit -a
core file size          (blocks, -c) 100000000
...   

What you're showing us is the conditions that prevail in your
interactive session.  That doesn't necessarily have a lot to do with
the ulimits that init-scripts run under ... 

Those are the ulimits of the db_admin account (i.e., the user that set up and runs the DB processes). Is Postgres limited by other settings?

Regards,

Michael A.
Database Architect, Met.no