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

> 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?

Yes, you are right.  No way to disable transactions.

--  Bruce Momjian                        |  http://www.op.net/~candle maillist@candle.pha.pa.us            |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026