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
From | Date | Subject | |
---|---|---|---|
Next Message | 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 |