Search Postgresql Archives

Re: ERROR: Out of memory - when connecting to database

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



what's the work_mem?

64MB

that's *way* too much with 24GB of ram and>  1k connections. please
lower it to 32MB or even less.

Thanks for your reply. You are generally right. But in our case most of the backends are only waiting for notify so not consuming any work_mem. The server is not swapping. On the other hand some queries profit from it. So we think it's fine as is.

Regards,

Kuba


--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux