Received: from postgresql.org.org (webmail.postgresql.org [216.126.85.28]) by postgresql.org (8.11.3/8.11.1) with SMTP id f3F4iZu13173 for ; Sun, 15 Apr 2001 00:44:35 -0400 (EDT) (envelope-from pgsql-sql-owner@postgresql.org) Received: from news.tht.net (news.hub.org [216.126.91.242]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f3EDPJ878647 for ; Sat, 14 Apr 2001 09:25:19 -0400 (EDT) (envelope-from news@news.tht.net) Received: (from news@localhost) by news.tht.net (8.11.1/8.11.1) id f3ED4g792127 for pgsql-sql@postgresql.org; Sat, 14 Apr 2001 09:04:42 -0400 (EDT) (envelope-from news) From: "Sergey E. Volkov" X-Newsgroups: comp.databases.postgresql.sql Subject: Same question about PostgreSql Date: Sat, 14 Apr 2001 17:01:13 +0400 Organization: Hub.Org Networking Services (http://www.hub.org) Lines: 41 Message-ID: <9b9ht5$2pup$1@news.tht.net> X-Complaints-To: scrappy@hub.org X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.50.4522.1200 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 To: pgsql-sql@postgresql.org X-Archive-Number: 200104/232 X-Sequence-Number: 2582 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.