Re: Read only transactions - Commit or Rollback - Mailing list pgsql-performance

From Andreas Seltenreich
Subject Re: Read only transactions - Commit or Rollback
Date
Msg-id 87mziwj6na.fsf@gate450.dyndns.org
Whole thread Raw
In response to Re: Read only transactions - Commit or Rollback  (Markus Schaber <schabi@logix-tt.com>)
Responses Re: Read only transactions - Commit or Rollback  (Markus Schaber <schabi@logix-tt.com>)
List pgsql-performance
Markus Schaber writes:

> As I said, there usually are no writing transactions on the same database.
>
> Btw, there's another setting that might make a difference:
>
> Having ACID-Level SERIALIZABLE or READ COMMITED?

Well, if nonrepeatable or phantom reads would pose a problem because
of those occasional writes, you wouldn't be considering autocommit for
performance reasons either, would you?

regards,
Andreas
--

pgsql-performance by date:

Previous
From: Michael Riess
Date:
Subject: Re: Read only transactions - Commit or Rollback
Next
From: Markus Schaber
Date:
Subject: Re: Read only transactions - Commit or Rollback