Hi group,
We have a DSS system based on Informix IDS and number of OLTP systems based
on Interbase.
After we was running this system, we had have a unceasing serious problems
with Interbase.
1) Massive inserts, updates, deletes is crashed database internal structure
!!!.
we have to make backup and restore every night ( backup and restore for 1G
database is spent about 3 hours !!).
2) Garbage collection is crashed database internal structure !!!!!!!!!!
3) Backup sometimes can't process crashed database.
4) Restore frequently ( 50% of cases ) can't help ( because backup is not
valid even if backup utility is finished without errors ( constraints
violation and etc. ) !!!!)
OLTP database has about 300 tables and 250 store procedures.
Number of client connections 100 and less.
Maximum database size is about 1.5 G - 3 G.
Data from the OLTP systems periodically come into DSS database.
Excuse me for long entering. Finally questions.
How stable is PostgreSql ?
I know, PostgreSql doesn't support 'prepare ' operation, is it successful to
use one for OLTP databases ?
Thanks for responds.
Good luck.
Sergey.