April 16th, 2002, 11:09 PM
An example of PostgreSQL performance!!!
For any doubting the ability of PostgreSQL to handle high-traffic sites with large datasets, check out http://archives.postgresql.org/
This site hosts a searchable index of every single item in all PostgreSQL newsgroups and mailing lists, since 1997-98. I'm guessing there are probably over a million entries in here. I know that my current stored emails from the postgreSQL lists just for the past 4 months has over 8000 entries, and I only subscribed to four lists.
This is just a standard Pentium (or dual pentium) webserver, with 3 GB RAM, and 2 SCSI disks (no RAID). Nothing extraordinary, but all the database-driven menus are as snappy as can be, and searches that return 25,000 results happen in just a few seconds. (but let's not slashdot the site with useless searches, please )
So anyway, the archive administrator, Marc Fournier, mentioned in the list:
Sounds like a winner to me...
April 26th, 2002, 11:18 PM
this is awesome news... good observation rycamor