Received: from mail.enterprise.net (mail.enterprise.net [194.72.192.18]) by hub.org (8.9.3/8.9.3) with ESMTP id EAA59590 for ; Fri, 27 Aug 1999 04:33:59 -0400 (EDT) (envelope-from olly@lfix.co.uk) Received: from linda.lfix.co.uk (root@max03-027.enterprise.net [194.72.196.27]) by mail.enterprise.net (8.8.5/8.8.5) with ESMTP id JAA28426; Fri, 27 Aug 1999 09:33:50 +0100 (GMT/BST) Received: from linda.lfix.co.uk (olly@localhost [127.0.0.1]) by linda.lfix.co.uk (8.9.3/8.9.3/Debian/GNU) with ESMTP id JAA17612; Fri, 27 Aug 1999 09:33:44 +0100 Message-Id: <199908270833.JAA17612@linda.lfix.co.uk> X-Mailer: exmh version 2.0.2 2/24/98 (debian) To: Bruce Momjian cc: Hamid Khoshnevis , pgsql-sql@postgreSQL.org Subject: Re: [SQL] Don't need transaction integrity - can I turn it off In-Reply-To: Message from Bruce Momjian of "Fri, 27 Aug 1999 01:51:14 EDT." <199908270551.BAA10135@candle.pha.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Date: Fri, 27 Aug 1999 09:33:44 +0100 From: "Oliver Elphick" Bruce Momjian wrote: >[Charset iso-8859-1 unsupported, filtering to ASCII...] >> My application requires very fast update/insert- where I am told mySQL >> shines. Can I turn off commit/rollback in Postgres so as to dramatically >> speed up insert/updates. I understand and accept the cost of dropping som >e >> insert/updates. > >Yes, we have no-fsync option. See FAQ. But that has to do with not forcing a sync to disk after every write. I've never heard of an ability to disable transactions; isn't every operation outside an explicitly-declared transaction made a single separate transaction by default? -- Vote against SPAM: http://www.politik-digital.de/spam/ ======================================== Oliver Elphick Oliver.Elphick@lfix.co.uk Isle of Wight http://www.lfix.co.uk/oliver PGP key from public servers; key ID 32B8FAA1 ======================================== "But the end of all things is at hand; be ye therefore sober, and watch unto prayer. And above all things have fervent love among yourselves; for love shall cover the multitude of sins." I Peter 4:7,8