Обсуждение: Max user connections from Postgres Linux 7.2.1
Can someone tell me what the maximum user limits I can expect from a redhat 7.2+ server running postgres 7.2.1? I am about to develop a large number of projects using the postgres engine, and need to know if and or what limitations I will run into on the user access side. If this is covered in a faq that I have missed, I apologize ahead of time. I have at least tried to do my homework. Thanks,
chris.gamble@CPBINC.com writes: > Can someone tell me what the maximum user limits I can expect from a redhat > 7.2+ server running postgres 7.2.1? The maximum number of connections will largely depend on the hardware in the box (which you didn't mention ...) -- I'd bet you could run 512 or 768 simultaneous connections on Linux 2.4 with a beefy enough machine. Cheers, Neil -- Neil Conway <neilconway@rogers.com> PGP Key ID: DB3C29FC
Sounds great. In this scenerio, what would be considered beefy enough for that type fo user load? Or is there a place in an FAQ or something that can somewhat define how much extra resources are required for each extra user? And thank you for the rapid response, it never fails to completely boogle my mind at how fast and accurate the assistance on using postgres is. > -----Original Message----- > From: Neil Conway [SMTP:nconway@klamath.dyndns.org] > Sent: Monday, August 12, 2002 10:40 AM > To: chris.gamble@CPBINC.com > Cc: PostgreSQL General > Subject: Re: [GENERAL] Max user connections from Postgres Linux 7.2.1 > > chris.gamble@CPBINC.com writes: > > Can someone tell me what the maximum user limits I can expect from a > redhat > > 7.2+ server running postgres 7.2.1? > > The maximum number of connections will largely depend on the hardware > in the box (which you didn't mention ...) -- I'd bet you could run 512 > or 768 simultaneous connections on Linux 2.4 with a beefy enough > machine. > > Cheers, > > Neil > > -- > Neil Conway <neilconway@rogers.com> > PGP Key ID: DB3C29FC
I don't know of any upper limit on the number of sessions, except hardware. I have heard it go into the thousands and I heard 10k once, though I am not sure on that. --------------------------------------------------------------------------- chris.gamble@CPBINC.com wrote: > Sounds great. In this scenerio, what would be considered beefy enough for > that type fo user load? Or is there a place in an FAQ or something that can > somewhat define how much extra resources are required for each extra user? > > And thank you for the rapid response, it never fails to completely boogle my > mind at how fast and accurate the assistance on using postgres is. > > > > > -----Original Message----- > > From: Neil Conway [SMTP:nconway@klamath.dyndns.org] > > Sent: Monday, August 12, 2002 10:40 AM > > To: chris.gamble@CPBINC.com > > Cc: PostgreSQL General > > Subject: Re: [GENERAL] Max user connections from Postgres Linux 7.2.1 > > > > chris.gamble@CPBINC.com writes: > > > Can someone tell me what the maximum user limits I can expect from a > > redhat > > > 7.2+ server running postgres 7.2.1? > > > > The maximum number of connections will largely depend on the hardware > > in the box (which you didn't mention ...) -- I'd bet you could run 512 > > or 768 simultaneous connections on Linux 2.4 with a beefy enough > > machine. > > > > Cheers, > > > > Neil > > > > -- > > Neil Conway <neilconway@rogers.com> > > PGP Key ID: DB3C29FC > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org > -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073