Read only transactions - Commit or Rollback

From: Markus Schaber <schabi(at)logix-tt(dot)com>
To: PostgreSQL Performance List <pgsql-performance(at)postgresql(dot)org>
Subject: Read only transactions - Commit or Rollback
Date: 2005-12-20 10:40:53
Message-ID: 43A7DFB5.3030408@logix-tt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hello,

We have a database containing PostGIS MAP data, it is accessed mainly
via JDBC. There are multiple simultaneous read-only connections taken
from the JBoss connection pooling, and there usually are no active
writers. We use connection.setReadOnly(true).

Now my question is what is best performance-wise, if it does make any
difference at all:

Having autocommit on or off? (I presume "off")

Using commit or rollback?

Committing / rolling back occasionally (e. G. when returning the
connection to the pool) or not at all (until the pool closes the
connection)?

Thanks,
Markus

--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf. | Software Development GIS

Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Nörder-Tuitje 2005-12-20 10:55:23 Re: Read only transactions - Commit or Rollback
Previous Message Jignesh K. Shah 2005-12-20 06:44:39 Re: High context switches occurring