Thread: Is Postgres good for large Applications
Hi All Is Postgres good for large Applications ?? I mean where we have to make many simulataneous connections... Thanks Sandeep
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-----