RE: Reliability Stability of PgSQL & it's JDBC driver

I am currently using PostgreSQL with a production system using JSP's and
Servlets. The system currently services 250,000 SQL hits a day. The only
problem that I have had is with the database pooling. I had to write my own
custom database pooling code because I wasn't able to find any that worked
appropriately for my situation. This is certainly not a Postgres issue
though. Postgres has performed excellently for my project. The main
problem that you have in a production system is the VACUUM of the database.
This will in most cases severely inhibit performance. If your system isn't
24x7, then you should be fine as you can schedule this for off times. I
believe that the need to vacuum the database will be removed in the next
version due to WAL functionality, but I'm sure someone else is better
qualified to explain that. I just wanted to vouch for the stability of
Postgres in a production environment.

---------------------------------------------
Nathan Barnett

-----Original Message-----
From: pgsql-general-owner(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org]On Behalf Of Nikhil G.
Daddikar
Sent: Tuesday, December 12, 2000 8:42 AM
To: pgsql-general(at)postgresql(dot)org
Subject: [GENERAL] Reliability Stability of PgSQL & it's JDBC driver

Hi Folks,

I am a fan of pgsql and have been using it for lots personal projects where
stability of PgSQL was not an issue and most of the time the machine was
close to me, so that I could restart the daemons whenever there was a
problem. However, now I am writing an ERP solution and am thinking of using
EJB along with Postgresql. What I am concerned about is the reliability and
stability of Postgresql and it's JDBC driver. Is anybody using Postgresql
and JDBC in a "production" environment? Has anybody faced any wierd
problems? For example, when I was using the tool TableGen (generates java
code from database table), I found out that some of it was not working
because PgSQL's JDBC driver didn't support getImportedKeys() and
getExportedKeys(). Now are there any such issues? I wouldn't like to hear
sometime later that, for example, there is no support for BLOBs as well.

Any personal experiences will be greatly appreciated.

Thanks for your time.

-ngd.