Hi,
We have tryed PostgreSQL as the backend of a Java application used to
collect orders and other information. Everything would have been fine but
for the lack of row-level locking, and some problems with processes that go
hanged when locked for to long. Also we have experienced a couple of
corruptions on a table that suffers the deletion and insertion of 46000
records every day, and some sporadic and misterious backend crashes.
Table-locking has forced us to quit from PostgreSQL and move to Oracle. So
if you need a read-only (or single user) database with moderate performance
(any comercial one is faster), PostgreSQL will probably give you what you
need in this other aspects: good SQL, ease of use and administration, really
thin JDBC type 4 driver; and you may find to need more of:
Export/import tools
Backend stability
Crash recovery
Programming interfaces doc.
Best luck,
Juan Alvarez Ferrando