From: Sergey E. Volkov <sve@raiden.bancorp.ru>
To: pgsql-sql@postgresql.org
Subject: Same question about PostgreSql
Date: Sat, 14 Apr 2001 17:01:13 +0400
Message-ID: <9b9ht5$2pup$1@news.tht.net> (raw)
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: sve@raiden.bancorp.ru
Subject: Re: Same question about PostgreSql
In-Reply-To: <9b9ht5$2pup$1@news.tht.net>
References: <9b9ht5$2pup$1@news.tht.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox