"Benjamin Krajmalnik" <kraj@xxxxxxxxxxx> writes: > 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. Quite honestly, you're living in fantasy land if you expect to support 1000 concurrently active backends on such a restricted server. Get yourself a connection pooler and knock down max_connections to 100 or so. regards, tom lane -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
