Linked by Eugenia Loli-Queru on Mon 21st Apr 2003 17:26 UTC
PostgreSQL is a robust, next-generation, Object-Relational DBMS (ORDBMS), derived from the Berkeley Postgres database management system. "PostgreSQL is one of the best-managed open source projects out there" a friend-in-the-know told me about 2 years ago, so today we feature a mini-interview with five members of the PostgreSQL team about their plans on the popular DB.
Permalink for comment
To read all comments associated with this story, please click here.
To read all comments associated with this story, please click here.
Recent Original Stories
Recent Comments
Headlines
Random Comments
Random Stories
Random OS Link
I've found Postgres' performance to be more than adequate (v 7.2.2 on FreeBSD). I did some stress testing with it and Jetty, it handled about 600,000 page hits in just over a day with the Jetty java process taking up most of the CPU time. This on a lowly single processor 450Mhz p3, 256 megs of ram, and 7200 EIDE HD.
After 10 minutes or so into the test, PostgreSQL's CPU usage starting increasing and increasing and there were more pgsqls active (I used connection pooling). I did an "analyze (tablename)" and after about 3 seconds cpu usage for postgresql dropped considerably. On a second note, using the JIT-enabled JDK1.4 for Jetty had HUGE HUGE HUGE performance gains compared to the non-JIT 1.3, so if you are planning on running a JSP/Servlet-based server I highly recommend using 1.4+the server VM.