Re: number of pgsql connections established.

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 olly(at)lfix(dot)co(dot)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