number of pgsql connections established.

[Ananthajothi]

Hello Sir,

I like to know in postgresql,
how many connections are established in the system?.
how many connections can be made?.

We are using linux.

Thanks
Regards
Ananthajothi. G
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

[Oliver Elphick]

On Thu, 2004-07-08 at 08:53, Ananthajothi wrote:

Hello Sir,

I like to know in postgresql,
how many connections are established in the system?.
how many connections can be made?.

We are using linux.

You can have as many as your machine's hardware will support; there is a
default allowance of 100, but this can be changed to whatever number you
like. However, each extra backend requires a certain amount of extra
memory, so the practical limit is set by your RAM and by the ability of
your processor(s) and I/O to cope with multiple simultaneous queries.

You will need to configure the Linux kernel to allow sufficient shared
memory and other required system resources.

--
Oliver Elphick ol**@lfix.co.uk
Isle of Wight http://www.lfix.co.uk/oliver
GPG: 1024D/A54310EA 92C8 39E7 280E 3631 3F0E 1EC0 5664 7A2F A543 10EA
========================================
"Delight thyself also in the LORD; and he shall give
thee the desires of thine heart."
Psalms 37:4
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly