Обсуждение: Scalability in PostgreSQL
Hi All, We are using PostgreSQL I want to know the scalability and concurrency controlb of postgreSQL. I want o know how many users can concurrently access postgreSQL. Your Quick response would be agreat value. Tnaks&rgds srihari
> Hi All, > > We are using PostgreSQL I want to know the scalability and concurrency > controlb of postgreSQL. > > I want o know how many users can concurrently access postgreSQL. http://www.us.postgresql.org/docs/faq-english.html#3.8 default is 32, scalable up, but it doesn't mention what the max is post version 6.5.... > > Your Quick response would be agreat value. > > Tnaks&rgds > srihari > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster
No compiled in max. You can do thousands. --------------------------------------------------------------------------- Jim wrote: > > Hi All, > > > > We are using PostgreSQL I want to know the scalability and concurrency > > controlb of postgreSQL. > > > > I want o know how many users can concurrently access postgreSQL. > > http://www.us.postgresql.org/docs/faq-english.html#3.8 > default is 32, scalable up, but it doesn't mention what the max is post > version 6.5.... > > > > > > > Your Quick response would be agreat value. > > > > Tnaks&rgds > > srihari > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 4: Don't 'kill -9' the postmaster > > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.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
Well then there is a max - and it's the number of sockets limited by the OS (some 32 in win9x, 64 in NT family, MAX_HANDLES or something on Linux) ----- Original Message ----- From: "Bruce Momjian" <pgman@candle.pha.pa.us> To: "Jim" <jim@fortunet.com> Cc: <pgsql-odbc@postgresql.org> Sent: Sunday, January 26, 2003 10:25 PM Subject: Re: [ODBC] Scalability in PostgreSQL > > No compiled in max. You can do thousands. > > -------------------------------------------------------------------------- - > > Jim wrote: > > > Hi All, > > > > > > We are using PostgreSQL I want to know the scalability and concurrency > > > controlb of postgreSQL. > > > > > > I want o know how many users can concurrently access postgreSQL. > > > > http://www.us.postgresql.org/docs/faq-english.html#3.8 > > default is 32, scalable up, but it doesn't mention what the max is post > > version 6.5.... > > > > > > > > > > > > Your Quick response would be agreat value. > > > > > > Tnaks&rgds > > > srihari > > > > > > ---------------------------(end of broadcast)--------------------------- > > > TIP 4: Don't 'kill -9' the postmaster > > > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 6: Have you searched our list archives? > > > > http://archives.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