Is Postgres good for large Applications

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.

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...

Thanks
Sandeep

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

--
Email: louis.gonzales@linuxlouis.net
WebSite: http://www.linuxlouis.net
"Open the pod bay doors HAL!" -2001: A Space Odyssey
"Good morning starshine, the Earth says hello." -Willy Wonka

Sandeep Kumar Jakkaraju wrote:

Is Postgres good for large Applications ??

Yes.

cf., e.g., "http://www.computerworld.com.au/index.php?id=760310963"

"...

Vice president of operations at Afilias, Ram Mohan said the .ORG
database will be based on a standard implementation of PostgreSQL
version 7.2, which Afilias also uses to manage the .INFO domain
registry. Overall, the transition across to a PostreSQL system should be
virtually invisible to .ORG users, he said.

Known mostly as the domain for non-commercial organisations, .org is the
Internet's fifth largest top-level domain, with more than 2.4 million
registered domain names worldwide.

ICANN selected PIR from amongst 11 organisations that had sought to
oversee the .ORG domain registry during an eight-month evaluation
process. PIR was created specifically to manage the .ORG registry by the
Internet Society, a nonprofit organisation founded to ensure the open
development of the Internet.

..."

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

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 10/18/06 20:47, Robert Treat wrote:

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.

Yabut, "Is Postgres good for ... many simulataneous connections" is
just soooo ambiguous.

Just a *little* hint of his volume needs and any sort of Google
search would have been welcome.

- --
Ron Johnson, Jr.
Jefferson LA USA

Is "common sense" really valid?
For example, it is "common sense" to white-power racists that
whites are superior to blacks, and that those with brown skins
are mud people.
However, that "common sense" is obviously wrong.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.5 (GNU/Linux)

iD8DBQFFNvY8S9HxQb37XmcRAhPDAJ9LGNO7T1Hox1lqDYZtk7N/0VblQwCg1Kjb
OpVGu/NhI4pn1gETn4B7Oik=
=k0lk
-----END PGP SIGNATURE-----