Postgres Pro
Downloads
Home   >   mailing lists

Thread: number of pgsql connections established.

number of pgsql connections established.

From
"Ananthajothi"
Date:
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

Re: number of pgsql connections established.

From
"Dann Corbit"
Date:
http://www.postgresql.org/docs/current/static/app-postmaster.html

> -----Original Message-----
> From: pgsql-general-owner@postgresql.org
> [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Ananthajothi
> Sent: Thursday, July 08, 2004 12:54 AM
> To: pgsql-general@PostgreSQL.org
> Subject: [GENERAL] number of pgsql connections established.
>
>
> 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

Re: number of pgsql connections established.

From
Oliver Elphick
Date:
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@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