Re: maximum number of client connections?

3000 clients = B of 6000(minimum) -> 6000 * 8KB = 48000KB
1MB = 1024KB
48000KB/(1024KB/MB) = 46.875 MB

is my math right? only 47MB??

reid

> -----Original Message-----
> From: Dann Corbit [mailto:DCorbit(at)connx(dot)com]
> Sent: Thursday, October 16, 2003 3:14 PM
> To: Mark Harrison
> Cc: pgsql-general(at)postgresql(dot)org
> Subject: Re: [GENERAL] maximum number of client connections?
>
>
> From:
> http://www.postgresql.org/docs/7.3/interactive/app-postmaster.
html

"-N max-connections
Sets the maximum number of client connections that this postmaster will
accept. By default, this value is 32, but it can be set as high as your
system will support. (Note that -B is required to be at least twice -N.
See the Administrator's Guide for a discussion of system resource
requirements for large numbers of client connections.)"

I hope you have lots of memory on that machine.

> -----Original Message-----
> From: Mark Harrison [mailto:mh(at)pixar(dot)com]
> Sent: Thursday, October 16, 2003 11:47 AM
> To: pgsql-general(at)postgresql(dot)org
> Subject: [GENERAL] maximum number of client connections?
>
>
> We have the situation where it would be convenient if we could support

> a large number (>1024, possibly in the 2000-3000
> range) of client connections.
>
> What are our options for this?
>
> Many TIA,
> Mark
>
> --
> Mark Harrison
> Pixar Animation Studios
> Emeryville, CA
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to
> majordomo(at)postgresql(dot)org
>

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org