Home > Archive > PostgreSQL JDBC > July 2005 > Client Connection vs. JDBC Connections vs. Postgres processes









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Client Connection vs. JDBC Connections vs. Postgres processes
Scott Goldstein

2005-07-26, 8:24 pm

Is the following equation true?

Postgres Client Connections = Open JDBC Connections = Postgres server processes

If so, I can configure the max for each through "max_connections" property, correct?
If not, how do they relate and how do I configure the resource limits?

Thanks.

Scott

Oliver Jowett

2005-07-26, 8:24 pm

Scott Goldstein wrote:

> Postgres Client Connections = Open JDBC Connections = Postgres server
> processes


Each Connection made using the postgres JDBC driver opens a connection
to the postmaster resulting in a new server process, yes. You might have
other postgres clients, too, and you might have non-postgres JDBC
connections that obviously don't affect the postmaster.

> If so, I can configure the max for each through "max_connections"
> property, correct?


Yeah.

-O

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql
.org so that your
message can get through to the mailing list cleanly

Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com