Re: Is Postgres good for large Applications - Mailing list pgsql-general

From Robert Treat
Subject Re: Is Postgres good for large Applications
Date
Msg-id 200610182147.44208.xzilla@users.sourceforge.net
Whole thread Raw
In response to Re: Is Postgres good for large Applications  (louis gonzales <gonzales@linuxlouis.net>)
Responses Re: Is Postgres good for large Applications  (Ron Johnson <ron.l.johnson@cox.net>)
List pgsql-general
On Wednesday 18 October 2006 01:47, louis gonzales wrote:
> Is your server capable?  Does it have enough resources to handle many
> connections?
>
> many = ???  100, 200, 1,000,000,000????     are they concurrent users?
>
> 'good for large applications' = ???     I'd say, how large your
> application is doesn't matter, right... cause that's the front end.  How
> well is it coded and does it make efficient logical SQL calls to a well
> structured database... that's another question.
>
> I've got a question, "who wants to play, ask 20 questions?"
>
> Sorry for the sarcasm... but this is now 2:00 a.m. EST, and questions
> have to be specific to warrant an answer.
>

You know Louis, it's not like you *have* to answer the question if you're
say... tired or, i don't know... maybe a bit cranky?  I mean I sympathize
with your response but on the other hand it's bound not to be 2:00 a.m.
somewhere in the world so you could just let those people deal with this one.

> If I were to say:
>
> many = YES
> good for large applications = YES
>
> Wouldn't you come back then with, "How many?" and "How large of
> applications?"
>
> Sandeep Kumar Jakkaraju wrote:
> > Hi All
> >
> > Is Postgres good for large Applications ??
> > I mean where we have to make many simulataneous connections...
> >

Sandeep,
PostgtreSQL has a list of users here: http://www.postgresql.org/about/users
Some limits are in the FAQ:  http://www.postgresql.org/docs/faqs.FAQ.html
And anecdotaly I've run systems that maintained 1000+ simultaneous connections
on fairly modest hardware as far back as 7.3, so mostly likely the answer for
you will be yes, but read the above and feel to post back with specific
questions.

--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL

pgsql-general by date:

Previous
From: Ron Johnson
Date:
Subject: Re: Newbie needs help with ERROR: could not write to file
Next
From: Robert Treat
Date:
Subject: Re: Any documatation about porting from Oracle to PostgreSQL