October 2nd, 2003, 02:27 AM
Type of application that use PostgreSQL
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.
October 2nd, 2003, 11:16 AM
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?
PostgreSQL, it's what's for dinner...
October 3rd, 2003, 04:30 AM
I am comparing postgreSQL to Oracle 8i.