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

From Toby
Subject Re: PostgreSQL JDBC - Number of connections
Date
Msg-id 5.1.0.14.0.20020929115123.00a887f0@mail.flirble.org
Whole thread Raw
In response to Re: PostgreSQL JDBC - Number of connections  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: PostgreSQL JDBC - Number of connections
List pgsql-jdbc
>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 ...


quite. forgive me if i'm wrong, but the backend spawns a new thread for
each connection, so if you want 1000+ simultaneous connections then you're
looking at 1000+ threads. unless you have many processors on your machine,
you will lose much performance through your machine busy context switching
between threads, rather than doing useful work.

t


pgsql-jdbc by date:

Previous
From: Barry Lind
Date:
Subject: Re: JDBC for 7.2.x
Next
From: Chris Thompson
Date:
Subject: COPY FROM