Re: "Out of memory" errors..

Lim Berger escribió:

> Thanks. I did "su postgres" and ran the ulimit command again. All
> values are the same, except for "open files" which is double in the
> case of this user (instead of 4096, it is 8192). Not sure what I can
> gather from that?

Try "su - postgres" instead (which will run the user start scripts and
may modify the ulimits for that user), but note that the ulimit can also
be changed in the script that starts the Postgres process on system
boot.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.