http://www.perlmonks.org?node_id=206997


in reply to Re: Re: MySQL vs SQL2000
in thread MySQL vs SQL2000

About the simultaneous connections: You must also keep in mind that these are the default installation values, that doesn't mean that PostgreSQL doesn't support more that 32 simultaneous connections, you just have to tweak the configuration file to make it possible. To me that output is just useless data, it doesn't speak about maximum values and/or scalability at all....
--
use signature; signature(" So long\nAlfie");

Replies are listed 'Best First'.
Re: Re: Re: Re: MySQL vs SQL2000
by diotalevi (Canon) on Oct 22, 2002 at 14:36 UTC

    To further expand on alfie - PostgreSQL's connection limit can be upped arbitrarily but that's limited by the amount operating system's shared memory. When I install PostgreSQL on OpenBSD I have to make a tweak to the kernel to up the maximum limit. This is all documented so it's nothing to worry about but it would be misleading to simply look at PostgreSQL's arbitrary 32 connection limit and ignore the OS's less but still arbitrary limit.

    __SIG__ printf "You are here %08x\n", unpack "L!", unpack "P4", pack "L!", B::svref_2object(sub{})->OUTSIDE;