Search Postgresql Archives

Re: Postgresql performance in production environment

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

 



On Sun, Aug 19, 2007 at 05:15:34PM +0800, Phoenix Kiula wrote:
> Well based on some past posts, I looked into my pg_log stuff and found
> a number of these lines:
> [----------------
> LOG:  could not fork new process for connection: Resource temporarily
> unavailable

Usually this message means that the *kernel* refused to let you fork a
new process. Some resource was unavailable. So this means (usually) one
of two things:

- You have a maximum on the number of processes on the system and
you're exceeding it
- You have a limit of the amount of memory. If you have overcommit
disabled this may be causing the issue.

I couldn't find quickly details of your setup but if you're running
linux with overcommit disabled, make sure you have at least twice as
much space allocated for swap as you have real memory.

Make sure you don't have lots of idle postgres processes lying around.
You'll have to provide more detail about your system before getting any
better recommendations.

Have a nice day,
-- 
Martijn van Oosterhout   <kleptog@xxxxxxxxx>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

Attachment: signature.asc
Description: Digital signature


[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