April 16th, 2002, 10:09 PM
|
|
Gödelian monster
|
|
Join Date: Jul 1999
Location: Central Florida, USA
|
|
|
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:
Quote: Oh, and, of course, its running on v7.2.1 now, which means that VACUUMs no
longer lock up the search ... last night, I had something like 367
indexers pounding away at the database *and* a VACUUM running *and* did a
search in <2 minutes (considering that is 367 simultaneous and active
connections to the database, I'm impressed) ... |
Sounds like a winner to me...
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
