Thread: Scalability in PostgreSQL

Scalability in PostgreSQL

From
srihari
Date:
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

Re: Scalability in PostgreSQL

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


Re: Scalability in PostgreSQL

From
Bruce Momjian
Date:
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

Re: Scalability in PostgreSQL

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