#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2003
    Location
    Switzerland
    Posts
    2
    Rep Power
    0

    Type of application that use PostgreSQL


    Hello,

    I am in the process to define if our product can use PostgreSQL.

    Do you know what type of application use PostgreSQL, and also what is the size of the database for these projects?

    Our application has a table with more than 300000 rows. There are complexe query with many joins. And we must respect some time constraints. Also the application is running 24 hours per day, so the product must be stable, with good recovery in case of problems.

    Thank you,
    Jean-Marc
  2. #2
  3. Me likey breadsticks...
    Devshed Beginner (1000 - 1499 posts)

    Join Date
    Jan 2003
    Location
    Los Angeles
    Posts
    1,189
    Rep Power
    18
    Postgres is known for it's scalability and performance under stress. There are case studies here

    Also, the .org registry runs off of postgres as well. There are known databases to be on the order of many terabytes of info, so 300,000 rows should be handled very easily.

    Which databases are you comparing postgres against?

    -b
    PostgreSQL, it's what's for dinner...
  4. #3
  5. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2003
    Location
    Switzerland
    Posts
    2
    Rep Power
    0
    I am comparing postgreSQL to Oracle 8i.

IMN logo majestic logo threadwatch logo seochat tools logo