Radovan Jablonovsky <radovan.jablonovsky@xxxxxxxxxxxx> wrote: > We are running PostgreSQL version 9.1.1 You should apply the latest bug fixes by updating to 9.1.4. http://www.postgresql.org/support/versioning/ > with 32GB of RAM, 32GB of SWAP and during high load we could reach > (swap + RAM) memory limit. If you're even *starting* to swap you're doing something wrong, much less exhausting swap space equal to actual RAM. What is your configuration? http://wiki.postgresql.org/wiki/Server_Configuration While it's probably a good idea to configure the OOM killer to behave more sanely, we tend to ignore it in favor of ensuring that it never comes into play. We run about 200 databases 24/7 and I think I've seen it kick in about twice -- when we ran queries that leaked memory on each row in a big query. -Kevin -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
