Re: PostgreSQL JDBC - Number of connections - Mailing list pgsql-jdbc

From Tom Lane
Subject Re: PostgreSQL JDBC - Number of connections
Date
Msg-id 4475.1033244255@sss.pgh.pa.us
Whole thread Raw
In response to Re: PostgreSQL JDBC - Number of connections  (Lars Nielsen Lind <moonie@worldonline.dk>)
Responses Re: PostgreSQL JDBC - Number of connections
List pgsql-jdbc
Lars Nielsen Lind <moonie@worldonline.dk> writes:
> Yes - but it seems to be possible with only -N 1024 as max_connections?

If you are finding that the backend won't take more than that, it's time
for an update.

There used to be a compile-time limit on max_connections, which was 1024
by default, but it's been gone for awhile.

BTW, you will probably find that you need to do some surgery on kernel
settings as well, if you really want to handle more than a thousand
concurrent backends ...

            regards, tom lane

pgsql-jdbc by date:

Previous
From: Lars Nielsen Lind
Date:
Subject: Re: PostgreSQL JDBC - Number of connections
Next
From: Barry Lind
Date:
Subject: Re: JDBC for 7.2.x