Received: from www1.newsfeed.net (IDENT:root@[209.181.150.249]) by hub.org (8.9.3/8.9.3) with ESMTP id AAA13441 for ; Fri, 27 Aug 1999 00:03:55 -0400 (EDT) (envelope-from hamid@pobox.com) Received: from local.nvcr1.bc.wave.home.ca (cr65160-a.nvcr1.bc.wave.home.com [24.113.25.106]) by www1.newsfeed.net (8.8.7/8.7.3) with SMTP id VAA23735 for ; Thu, 26 Aug 1999 21:59:33 -0600 From: "Hamid Khoshnevis" To: Subject: Not requiring commit? Date: Thu, 26 Aug 1999 21:12:05 -0700 Message-ID: <000f01bef042$52340040$6a197118@local.nvcr1.bc.wave.home.ca> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook 8.5, Build 4.71.2173.0 X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3 Importance: Normal Hello, We are running PG 6.5. We have a specialized database system which gets rebuilt from scratch at the end of the day. During the day, we need VERY FAST INSERT/UPDATES and don't care about database integrity too much, i.e. a few records can drop without affecting us. Is there any way to dramatically speed up the insert/update by turning integrity features (e.g. rollback capability) off. Your help is appreciated. hamid