Re: Max connections

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

 



Yes, I had, but apparently the values were not high enough to accommodate that many connections.

I retuned the IPC kernel setting, and now it appears to be running fine.

Thanks.

 

 

From: Shoaib Mir [mailto:shoaibmir@xxxxxxxxx]
Sent: Monday, August 10, 2009 11:51 PM
To: Benjamin Krajmalnik
Cc: pgsql-admin@xxxxxxxxxxxxxx
Subject: Re: Max connections

 

On Tue, Aug 11, 2009 at 3:42 PM, Benjamin Krajmalnik <kraj@xxxxxxxxxxx> wrote:

I am setting up a test environment to simulate a very high load.  We have a server farm which is receiving data (cold be thousands of simultaneous users posting data).  I currently have max_connections set to 500 and the server is starting ok.  If I try to increase the max_connections to 1000, the server is unable to start.  I am running a VM with 4GB RAM.  Swap space is not being used, and the system is showing about 1.5GB of ram not being utilized.

Are there any other config setting which should be changed together with max_connections to successfully start the postmaster?


Increasing max_connection will make PostgreSQL to request more System V shared memory or semaphores than your operating system's default configuration allow. Did you tune/tweak the kernel options for that? Details for those options can be found at

http://www.postgresql.org/docs/8.3/static/kernel-resources.html#SYSVIPC

--
Shoaib Mir
http://shoaibmir.wordpress.com/


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux