Re: [SQL] Don't need transaction integrity - can I turn it off - Mailing list pgsql-sql

From Michael Richards
Subject Re: [SQL] Don't need transaction integrity - can I turn it off
Date
Msg-id Pine.BSF.4.10.9908271853050.29442-100000@scifair.acadiau.ca
Whole thread Raw
In response to Don't need transaction integrity - can I turn it off  ("Hamid Khoshnevis" <hamid@emarq.com>)
List pgsql-sql
On Thu, 26 Aug 1999, Hamid Khoshnevis wrote:

> 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 some
> insert/updates.

Personally, I'd set it all up and give it a whirl first. Often I've found
that these things work better than I expected and don't need to be fiddled
with to get expected speeds.

-Michael



pgsql-sql by date:

Previous
From: Michael Richards
Date:
Subject: RE: [SQL] 2 million+ entries
Next
From: Michael Richards
Date:
Subject: indexes using datetime