postmaster, it will have 2GB of work_mem. No matter what the default
setting in your postgresql.conf file is. This will not affect any other
user.

Since these settings (work_mem and maintenance_work_mem) are limits per
database backend, you don't want to set them too high in the global
postgresql.conf file. You'd risk running into swapping. But certain
maintenance jobs as well as slon (when doing subscriptions) do need
rather unusual amounts of resources.


Regards,
Jan

-- 
Anyone who trades liberty for security deserves neither
liberty nor security. -- Benjamin Franklin