RE: [GENERAL] info on people running postgre

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