PostgreSQL on Big Sites?

An anonymous reader asks: "I've been using PostgreSQL for years on small projects, and I have an opportunity to migrate my company's websites from Oracle to an open-source alternative. It would be good to be able to show the PHBs that PostgreSQL is a viable candidate, but I'm unable to find a list of high-traffic sites that use it. Does anyone know of any popular sites that run PostgreSQL?"

Several examples

[IO ERROR]

See, for instance, PostgreSQL Case Studies [postgresql.org] and from the pgsql-advocacy [postgresql.org] mailing list comes some more: Finally, a list of *big* companies using PostgreSQL for *serious* projects. Why use PostgreSQL? Here's why [postgresql.org] for some examples.

The .org registry?

[tzanger]

Story [computerworld.com.au]

recent interview with Josh Berkus

[oreaq]

MadPenguin has an interview [madpenguin.org] with Josh Berkus, one of the core team members of PostgreSQL.

Need more info

[The Slashdolt]

Is your companies website essentially read-only page loading? If so, why not just go with MySQL. Do you really need MVCC in a read-only scenario?

On the other hand, If your company is doing transaction processing, like a customer facing product ordering system (think amazon), its a lot more than just having to sustain certain volumes. The reputation of your company and its ability to make money by selling products will rely entirely on your database. In a best case scenario there may be no difference between oracle and postgres. But imagine the worst case scenario. Peak volume, company is making $1M/hour in sales on the web, db dies and won't come up....who you gonna call?

There's more to the equation than up front cost and ability to handle volumes....

How's .org and .info

[snorklewacker]

SPI, the authoritative .org registrar, and Afilias, the authoritative .info registrar both use PostgreSQL for their registration databases.

Companies that use PostgreSQL

[bendsley]

Their website shows that BASF uses PostgreSQL as their DB.

www.basf.com

They're an enormous company. I've always heard too that PostgreSQL is much better for larger sites. Cannot say for sure though as I have never used it.

PGSQL

[hey!]

There's no reason however to write all your SPs in PLSQL. Oracle supports stored procedures in Java, as does Postgres.

This not only makes it easier in some instances to migrate some applications to PGSQL, it also improves performance (JIT compiling). You don't say exactly where the performance bottlenecks are, but this could improve performance and close the gap between PGSQL and Oracle.

That said, if you've been working for years on tuning your Oracle physical design to a fare-thee-well, it's going to be nearly impossible to beat, supposing the transaction volume and query performance are the chief issues.

Apple Remote Desktop

[dadragon]

Apple's remote desktop 2 package uses PostgreSQL for its data store.

link [apple.com]

OpenACS

[aquarian]

OpenACS has been Postgres-based for a long time, as a free alternative to Oracle. You can get plenty of Postgres information at www.openacs.org The folks there have been using it for years for all kinds of sites, so it's pretty well tested. OpenACS is a unique system using AOLServer and TCL, but the database performance should translate to whatever server/scripting platform you're using.

Note that PostgreSQL is being benchmarked...

[tcopeland]

...on some hefty hardware these days. This post [postgresql.org] talks about running it on a 16 CPU machine...

Re:The .org registry?

[jadavis]

and the .info registry

Both are run by Afilias, which is a big user and big developer of PostgreSQL. They're the ones that did the work on the Slony-I [slony.info] replication server.

PostgreSQL on Big Sites?

[Anonymous Coward]

We are an e-Learning company which started 4 years back with very little startup budget. We have been using Postgres for 4 years now and it has never let us down. We never imagined our company would grow so big so fast. Today we provide an ASP solution for over 10,000 users from around 20 companies. Postgres scales very well and is quite responsive. In the past we have had periods of 100% CPU utilization but postgres did not crash on us. You have to know how to configure it correctly and is will perform as well as a commercial DB.

Re:Need more info

[yamla]

FUD. MyISAM certainly can handle a database of larger than 2 gigs. It can even handle _tables_ larger than 2 gigs. "As you can see, MySQL remembers the create options exactly as specified. And it chose a representation capable of holding 91 GB of data." (p.38, High Performance MySQL: Optimization [sic], Backups, Replication & Load Balancing, by Jeremy D. Zawodny & Derek J. Balling, published by O'Reillly, April 2004.

Re:Several examples

[Anonymous Coward]

Northrop Grumman, US Navy:

Uses a J2EE application to store user profiles for the Navy Enterprise Portal and the Fleet Numerical Meteorology and Oceanography Center(FNMOC) Portal using JBoss application server and PostgreSQL database. Expose application via SOAP and RMI interfaces.

http://kennethbowen.com/kbresume.html

Re:recent interview with Josh Berkus

[Anonymous Coward]

Much of Fujitsu's sales are outside of software.

They make submarine/underseas telecommunication networks, the world's fastest optical amplifiers, semiconductors, nanotech/quantum-dots, point-of-sale systems, Sparcstations, ATM machines, LCDs, supercomputers (#14 on the "Top 500 supercomputers list), Sparc chips for Sun etc.

No doubt Oracle sells more software.