1. No Profile Picture
    Gödelian monster
    Devshed Regular (2000 - 2499 posts)

    Join Date
    Jul 1999
    Central Florida, USA
    Rep Power

    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:

    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...
    The real n-tier system:

    FreeBSD -> PostgreSQL -> [any_language] -> Apache -> Mozilla/XUL

    Amazon wishlist -- rycamor (at) gmail.com
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Mar 2001
    Rep Power
    this is awesome news... good observation rycamor


IMN logo majestic logo threadwatch logo seochat tools logo