Re: PostgreSQL JDBC - Number of connections

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Lars Nielsen Lind <moonie(at)worldonline(dot)dk>
Cc: Toby <toby(at)paperjet(dot)com>, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: PostgreSQL JDBC - Number of connections
Date: 2002-09-28 20:17:35
Message-ID: 4475.1033244255@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Lars Nielsen Lind <moonie(at)worldonline(dot)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

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Lars Nielsen Lind 2002-09-28 21:15:11 Re: PostgreSQL JDBC - Number of connections
Previous Message jonerf1 2002-09-28 20:04:48 connecting from openoffice